When sql queries running very slower we can consider forcing an index using WITH INDEX command Syntax: Select * from <tablename> with (index(<index name>)) This we found very useful in one of our project where we were faced performance issues. Our code is basically querying a table with date condition. select @st_dt = max(field1) from table1 with (index (index_nm)) where field1 <= @start_dt The date value is passed through sql variable. The query is running for ever even though it...