例如:select top 6 * from Member_Product where mp_commend=2 and mp_member not in (select mb_id from member_table where mb_isvip=1) order by Mp_Id desc是仅对Member_Product 建立索引 还是对Member_Product 和member_table都建立索引,要不要建立视图?
建立索引 还是对Member_Product的mp_commend\mp_commend 和member_table的mb_isvip\mb_id都建立索引select * from Member_Product a where mp_commend=2 and not exists(select 1 from member_table where mb_isvip=1 and mb_id=a.mp_member)
建立索引 还是对Member_Product的mp_commend\mp_commend 和member_table的mb_isvip\mb_id都建立索引select * from Member_Product a where mp_commend=2 and not exists(select 1 from member_table where mb_isvip=1 and mb_id=a.mp_member)