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
What is number function in sql?
What is dbo in sql?
How to get each name only once from an employee table?
What is trigger and stored procedure in sql?
how to check myisam tables for errors? : Sql dba
What is the maximum rows in csv?
How sql query is executed?
How exception is different from error?
Is sql considered coding?
What does select count (*) mean in sql?
What is on delete set null?
How can we solve sql error: ora-00904: invalid identifier?
Why functions are used in sql?
explain mysql aggregate functions. : Sql dba
Why do you partition data?