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 !!?
- 3 Answers
- 11518 Views
- eBay, I also Faced
- E-Mail Answers
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 date and time functions in mysql? : Sql dba
How show all rows in sql?
What is range partitioning?
How do you remove duplicate records from a table?
What are different types of indexes?
What is a sql schema used for?
How delete all records from table in sql?
How do I copy a table in sql?
Are left and right joins the same?
How do I count records in sql?
What is sql mysql pl sql oracle?
What is difference between primary and secondary key?
What is the use of & in pl sql?
What is using in sql?
Why we use sql profiler?
