Viewing 3 posts - 1 through 4 (of 4 total)
well , the entire table rows count was approximatively 1,050,000 records and the selected count was 1,000,000 records and no other indexes exist .
I tried first to select all columns...
March 13, 2009 at 4:37 pm
#959551
yea its solved , thx very much for ur aid .
the problem was that the percentage of data selected is to big, so indexing does not improve the query response...
March 12, 2009 at 1:27 pm
#958671
i tried what u say but still no improvement in query response time 😉 .
March 10, 2009 at 6:13 am
#956704