Avoid the sub queries. Where condition should be based on primary key and

How do you optimize SQL queries ?

Question Posted / asr

6 Answers
35893 Views
CarrizalSoft Technologies, Infosys, Oracle, I also Faced
E-Mail Answers

Answer Posted / asr

Avoid the sub queries.
Where condition should be based on primary key and index,
use primary column for join.
Try to avoid more tables.
Use temp tabels.
Create procedure.

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the features of pl sql?

1067

Is vs as in pl sql?

987

what is the stuff function and how does it differ from the replace function? : Sql dba

1058

How much does sql cost?

1007

Is sql a dbms?

1015

How do you bind variables in pl sql?

1097

Explain the the delete statements in sql?

1063

how to get help information from the server? : Sql dba

942

What is record in pl sql?

1084

What is query execution plan in sql?

1189

What is the best sql course?

985

How many sectors are in a partition?

1076

Can dml statements be used in pl/sql?

1081

What is a pragma statement?

1263

What is sp_helptext?

1069