Can any one tell me how to increase the performance of a
sql query ie what are the performance tips in creating or
writing a sql query !!?
Answer Posted / manoj
1.
Use proper sequence of tables in from clause
i.e.
the table have more common column must in last
in form clause bcoz on firing of query engine link
last table in form clause
2.
Use "Exist" clause instead of "Not in"
Bcoz it return only true/false(boolean)
3.
Use "Hint" if Required
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are pl sql data types?
What is a sql*loader control file?
How many types of relationship are there?
What are the sql versions?
Is pl sql useful?
What is your daily office routine?
How can you fetch first 5 characters of the string?
What is primary key sql?
How to sort the rows in sql.
what are the advantages of mysql in comparison to oracle? : Sql dba
Can variables be used in sql statements?
What is the difference between a query and a report?
What are the two parts of design view?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba