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

How do you optimize SQL queries ?

Question Posted / asr

6 Answers
35582 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

Can you select everything, but 1 or 2 fields, without writer's cramp?

931

Inline the values in PL/SQL, what does it mean.?

1156

How do you declare a constant?

910

What is the difference between between and in condition operators?

939

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1124

Is pl sql different from sql?

936

Is left join inner or outer?

962

how to load data files into tables with 'mysqlimport'? : Sql dba

1032

Is inner join same as self join?

1060

What is sql indexing?

963

What is difference between procedure and trigger?

915

How to Execute a Package in PL/SQL.?

1109

What is string join?

932

what are all the different normalizations? : Sql dba

960

is it possible to pass an object or table to a procedure as an argument?

1059