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
- 11517 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 write a subquery?
Can we commit in trigger?
what are the properties and different types of sub-queries? : Sql dba
How do I audit the sql sent to the server?
What does trigger mean in slang?
What is the difference between left and left outer join?
How do you create a unique index?
What is sql rowcount?
Can we rollback after truncate?
Write a query to display the current date in sql?
How many types of normalization are there?
How do I tune a sql query?
Does group by remove duplicates?
What is procedure and function?
what is the syntax used for partition in tsql? : Transact sql
