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

How do you optimize SQL queries ?

Question Posted / asr

6 Answers
36094 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 different types of functions in sql?

1097

What are the three pl sql block types?

1046

What is sql query optimization?

1178

How do I run a query in pl sql developer?

1046

What are sql ddl commands?

1134

How do I access sql anywhere database?

1017

Where can I learn sql for free?

1035

Does sql use python?

1088

how to check server status with 'mysqladmin'? : Sql dba

1130

Explain the uses of database trigger.

1169

What is the sql query to display the current date?

1087

what is bcp? When is it used?

1172

How can I change database name in sql?

1148

What is use of trigger?

980

What is a field in a database?

1097