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
- 12492 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
Describe different types of general function used in sql?
Which is better cte or subquery?
How many types of cursors are available in pl/sql?
What does truncate mean in sql?
what is text? : Sql dba
What does cursor do in sql?
State few characteristics of pl/sql?
How to use transactions efficiently : transact sql
How do you break a loop in pl sql?
What is bulk compiling in pl/sql.?
What is numeric function sql?
Is sql microsoft?
Which join is like an inner join?
What is cursor explain with example?
Explain the difference between 'between' & 'and' operators in sql
