Speeding up Queries

[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.

[pando]

count(1) and count(*) is same, no difference at all

[SANJAY_G]

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

[hany]

Hi pando,
According to Couchman's using count(1) is more effecient than using count(*).

[pando]

you can try it yourself, set autotrace on and look explain plan and statistics

compare them and you will see they are the same

[Orca777]

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]