Currently we have database which we reindex tables every night. Therefore, in the next morning If I query records from the previous day or earlier the query results are displayed with minimal time span. The weird part comes in; if I use the same query select statment to query records that were inserted in the curent date(the morning) it takes over 10mins to execute the query select statment and display the results. I have no issues querying with previous day data but only the current day data after 1000+ insert records where inserted into the database. Any Ideas?