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

How do you optimize SQL queries ?

Question Posted / asr

6 Answers
35805 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 compound trigger?

1025

What is the meaning of disabling a trigger?

1159

How do you remove duplicates without using distinct in sql?

969

Does mysql_real_escape_string prevent sql injection?

940

Is subquery faster than join?

1008

How to change the order of columns in Oracle SQL Plus ?

1047

What is the maximum number of columns in sql table?

1163

How do I add a primary key to a table?

1038

What are sql functions? Describe in brief different types of sql functions?

1087

What is a sql select statement?

1030

What are the two types of periodical indexes?

929

How to pronounce postgresql?

1045

What do you understand by case manipulation functions?

1023

Differentiate between sga and pga.

1153

What is the basic form of sql query?

932