I have a reporting procedure that fetches a great deal of data
and is currently taking too long to retrieve the results (40 sec).
Looking at the execution plan, I see SQL is not using some of the indexes I added especially for the queries benefit (ie.time column), usually it uses the clustered composite PK.
Does anyone know how I can force SQL to use a particular index on
Originally posted by DesmondX
thanks...still needed the syntax!
drop table test13
create table test13(id int identity primary key, code varchar(10))
create index i_test13 on test13 (code)
select * from test13 with(index(i_test13))
select * from test13 (index=i_test13)