??????stuMarks???writtenExam?д?????????
USE stuDB
GO
IF EXISTS (SELECT name FROM sysindexes
WHERE name = 'IX_writtenExam')
DROP INDEX stuMarks.IX_writtenExam
/*--?????д?????????????????????30??--*/
CREATE NONCLUSTERED INDEX IX_writtenExam
ON stuMarks(writtenExam)
WITH FILLFACTOR= 30
GO
/*-----????????? IX_writtenExam ???----*/
SELECT * FROM stuMarks  (INDEX=IX_writtenExam)
WHERE writtenExam BETWEEN 60 AND 90
?????????????????SQL Server?????????????????????????????????????????SQL Server??????????????????????????????? ??
???????????????
????* ???
????–?????????
????–????е???
????* ???
????–??????????????????????????洢???
????–???????????????????????????????????????????????и???
????????????????????
????* ???????б??????????????С?
????–???????????????
????–????????????????????
????* ????????????д?????????
????–???н?????????????????
????–???н????????С??С???????????????????????SQL Server???????????????????????????????????????????????????