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
- 12339 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 are different types of statements supported by sql?
Which nosql database is best?
What is the command used to fetch first 5 characters of the string?
does sql support programming? : Sql dba
What are all types of user defined functions?
What is the difference between inner join and outer join?
What are the types of dbms?
What is an ndf file?
How do you optimize a query?
How do I view a sql trace file?
What are sql indexes?
what are date and time data types in mysql? : Sql dba
What are the parts of a sql statement?
What is a function in oracle pl sql?
Why use stored procedures?
