问一条简单的sql语句效率问题存储过程如下SQL codeBEGINSELECT * FROM `literature` where `status`1 and
问一条简单的sql语句效率问题
存储过程如下
- SQL code
BEGIN SELECT * FROM `literature` where `status`=1 and auditstatus=2 and UID in(select ItemId from userfavdata where GroupName='literature' and deviceID=`pDeviceId` ) order by literatureYear,MagazineName;END
参数为
- SQL code
IN `pDeviceId` char(36)
[解决办法]
UID
ItemId 上建立索引