Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12346 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 is the use of prepared statement?
Explain constraints in sql?
Which is the correct statement about truncate and delete?
How do I debug a stored procedure?
Why is stored procedure faster than query?
What is trigger and types?
Can we join more than 2 tables in sql?
What is the function that is used to transfer a pl/sql table log to a database table?
What is integrity in sql?
Can a primary key be a foreign key?
Is natural join same as inner join?
When is the explicit cursor used ?
How does sql developer connect to oracle database?
How can you save or place your msg in a table?
What is difference between mysql and postgresql?
