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 / 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
Why coalesce is used in sql?
Explain the savepoint statement.
What is the use of nvl function?
What is varchar sql?
What is dml with example?
How can we link a sql database to an existing android app?
what is oltp (online transaction processing)? : Sql dba
Does google use sql?
What is view explain with example?
What is the sql*loader? : aql loader
Why sql query is slow?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
How would you convert date into julian date format?
how to dump a table to a file with 'mysqldump'? : Sql dba
Does sql*plus have a pl/sql engine?