we have a table that contains around 25,00,000 rows.The where clause is on month-year. Indexes in a sql query are picking up sometimes but the same query is not picking same indexes at different time The query is picking up the index some times but the exactly same query is not picking those indexes when we checked later. we have analyzed table,rebuilt index but it is still not picking indexes. Is...

sofia

• Sep 12th, 2014

Yes it is.

Answer Question  Select Best Answer