-
Hi guys,
what are the best methods to be taken into consideration when writing a query in order to speed up the performance?
For instance i know that using Count(1) is more effeicent than using Count(*).
any similar examples would be highly appreciated.
-
count(1) and count(*) is same, no difference at all
-
1. Do not use functions in where cluase, it will not use the indexe unless you have FBI.
2. Make use of hints to improve performance.
3..
Three are more "sql good practices" to follow do not remember right now..
Sanjay
-
Hi pando,
According to Couchman's using count(1) is more effecient than using count(*).
-
you can try it yourself, set autotrace on and look explain plan and statistics
compare them and you will see they are the same
-
Originally posted by hany
Hi guys,
what are the best methods to be taken into consideration when writing a query in order to speed up the performance?
For instance i know that using Count(1) is more effeicent than using Count(*).
any similar examples would be highly appreciated.
Hello;
On this site there is an introduction for Tuning; Look at it!
Orca
[Edited by Orca777 on 06-13-2002 at 05:38 AM]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|