大数据查询优化
大家好,我有一张表,有数据200多万,通过SQL可以查询出来60多万,但是需要30s,请问如何优化?
查询条件字段已加索引,但是此字段值较单一,只有0和1
SELECT MemberID,
RowID,
NickName,
HeadPhoto,
QRCode,
Sex,
RegNumber,
Phone,
Email,
EmailAuthen,
PhoneAuthen,
RealNameAuthen,
BankCardAuthen,
ConformBankAuthen,
TotalProductPrice,
TotalInterest,
YesterdayInterest,
AccountBalance,
IsLockBalance,
TotalIntegral,
StringData,
WeChat,
QQ,
Status,
DeviceType,
DeviceInfo,
DeviceID,
RegisterIp,
IsGetFreeProduct,
IsBuyNewSpecial,
FreeProductPrice,
DeviceMacAddress,
DeviceIDFA,
AppShortVersion,
DeviceIosVersion,
DeviceMacMd5,
IsRecharge,
MyFriendQRCode,
Sequnce,
CreateBy,
CreateTime,
LastUpdateBy,
LastUpdateTime,
IsDelete,
FrozenAmt
FROM NF_Member
WHERE IsDelete = 0