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

How do you optimize SQL queries ?

Question Posted / asr

6 Answers
35616 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 is sql and explain its components?

1018

Differentiate pl/sql and sql?

1021

What are the advantages of sql? Explain

1060

Explain locks? : Transact sql

965

Which command is used to delete a package?

1107

How is data stored in sql?

1007

How many types of cursors are available in pl/sql?

1051

What is the difference between mdf and ndf files?

1070

explain the difference between delete , truncate and drop commands? : Sql dba

1030

What is the current version of sql?

983

What is not null in sql?

992

what is text? : Sql dba

1014

How do you modify a table in sql?

1075

What are the two types of cursors in pl sql?

1012

What is left inner join in sql?

992