var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Select query takes time
I am using a select query. It takes long time to print in the records. the search condition was made on indexed field only. could u suggest some ways so that we could improve the fecth time.
thanks in advance.
Impossible to say on the information given so far. Have you tried AUTOTRACE or EXPLAIN to see what is happening?
i took explain plan and the explain plan shows, its using index. The number of records in the table is 400 Millions
and your where clause is selecting how many rows out of 400 Million?
Did you use ORDER BY clause in your query? If so, it might be the reason it takes a long time to display the output.
BTW, listing 4E8 records will take a long time, no matter what you do.