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
- 12194 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
Are sql database names case sensitive?
What is a native sql query?
what are the different index configurations a table can have? : Sql dba
Can we join 3 tables in sql?
What is synonyms?
What does plv msg allows you to do?
Whis is not false in primary key?
What is the difference between function and procedure in pl/sql?
How delete all data from all tables in sql?
What are the operators in sql?
What is sql and also describe types of sql statements?
What is sqlservr exe?
What is sql procedures and functions?
What is self-join and what is the requirement of self-join?
What is pl sql record in oracle?
