tariq_oracle

 Profile Answers by tariq_oracle 

• Apr 25th, 2008

 

1> always avoid select * from<table_name>
2> do not use in operator

Imran_Javed

 Profile Answers by Imran_Javed 

• May 8th, 2008

 

First look at the explain plan if there is any full scan. Then add appropriate index on columns that are used in the query. Basically, always add index on foreign key and the date columns (Most of the application access tables based on dated)

sampra

 Profile Answers by sampra 

• Mar 6th, 2012

 

1> always avoid select * from
2> do not use in operator