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
- 12388 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
What is self-join and what is the requirement of self-join?
Which tcp/ip port does sql server run?
Difference between truncate, delete and drop commands?
How many types of relationship are there?
what does myisamchk do? : Sql dba
What is the difference between local variables and global variables?
What is lookup table in sql?
what is auto increment? : Sql dba
What are the different types of triggers?
What is a sql instance vs database?
What is set serveroutput on in pl sql?
what are null values? : Sql dba
Mention what is the plv (pl/vision) package offers?
How to display Row Number with Records in Oracle SQL Plus?
What is a pdo connection?
