Execution of queries

[chaya]

hi,
I want to know, how can we decrease the execution time of sql queries?

Please help me

[jkoopmann]

don't know what db you are using but the methodology is to find where a query is spending its time (disk reads, sorts, memory access, ...something else) and then tune that part for the query. this is often accomplished by tracing the sql or running it through an explain plan analysis.

answers could be hardware reconfiguration, sql rewrite, adding indexes, redesign tables...