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 multiple partition?
Explain isolation levels. : Transact sql
How to use transactions efficiently : transact sql
How do I view a procedure in sql?
what is unique key constraint? : Sql dba
what are the authentication modes in sql server? : Sql dba
How do I make my sql query run faster?
How do I start pl sql?
When to use inner join and left join?
what is a join? : Sql dba
What is flag in sql?
What is the starting oracle error number? What is meant by forward declaration in functions?
Does asenumerable execute the query?
How do I edit a stored procedure?
Mention what is the plv (pl/vision) package offers?