Oracle PLSQL 里的索引记得是这样的:/*++index(index_name)*/
Select /*+INDEX(BSEMPMS SEX_INDEX) USE SEX_INDEX BECAUSE THERE ARE FEWMALE BSEMPMS */ FROM
BSEMPMS Where SEX='M';
SQL SERVER T-SQL里却是这样的。以前真没接触过
select * from stumarks (index = stumarks.IX_Stumarks_LabExam)
where labexam between 60 and 90
而在高版本中不支持上述写法
select * from stuMarks with(index='stumarks.IX_StuMarks_LabExam')
where labExam between 60 and 90