GeekInterview.com
Series: Subject: Topic:
Question: 2 of 33

Indexes in a sql query issue

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 this behavior of indexes possible where the same index is getting picked up yesterday but it is not getting picked up today
Asked by: anurag.tiwari_1986 | Member Since Mar-2012 | Asked on: Mar 13th, 2012

View all questions by anurag.tiwari_1986

This Question is not yet answered!

Related Open Questions

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.