Ramprasad K

• May 30th, 2006

 

Hi,

By tuning the query we can increase the execution speed with following TUNING TOOLS

 

MONITOR  

SQL_TRACE and TKPROF

 

EXPLAIN PLAN  

 

ORADBX 

 

ANALYZE

 

UTLBSTAT (begin) and UTLESTAT (end)  

 

 

 

-Thanks Alot.

sushilsb

 Profile Answers by sushilsb 

• May 30th, 2006

 

Standard practice is -

1. Indexed the columns (Primary key)

2. Use the indexed / Primary key columns in the where clause

3. check the explain paln for the query and avoid for the nested loops / full table scan (depending on the size of data retrieved and / or master table with few rows)

Syed Jawahar

• May 31st, 2006

 

HI

YOU CAN SPEED UP THE QUERY BY USING THE ROWID IN THE SELECT STATEMENT.

Srinivasa Bhargava

• Jul 27th, 2007

 

You have to index the columns properly and make sure that driving columns of the composite indexes are used in the query .
You may as well wish to rebuild indexes as the number of records is increased.