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
- 12497 Views
- eBay, I also Faced
- E-Mail Answers
Answer Posted / sathishrpillai
Hii..
for optimization of sql query
1.don't use select * from,choose particular fields itself
2.don't use both OR ,AND in same query
3.Minimise the use of aggreagate functions such sum,count
4.don't link unneccessary tables
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
How do you delete a table?
What is an alias command?
Differentiate between syntax and runtime errors.
How to read/write files from pl/sql?
What are different categories of sql commands?
What is the difference between the sql*loader and import utilities? : aql loader
Is sql developer case sensitive?
What is character functions?
How to Declare Fixed Length String Value In PL SQL
Which command is used to call a stored procedure?
What is the purpose of the sql select top clause?
What are the advantages of pl sql over sql?
What are the types of subqueries?
what is online transaction processing (oltp)? : Sql dba
What is the difference between python and sql?
