optimized count [message #19249] |
Wed, 06 March 2002 20:08 |
Srinivas
Messages: 138 Registered: June 2000
|
Senior Member |
|
|
If i have a table with more than a million records.
Is there any better way to get the count of those records without using "Count " Function.
Thanks in advance
Srinivas
|
|
|
|
Re: optimized count [message #19266 is a reply to message #19251] |
Thu, 07 March 2002 09:37 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
is the designed, fastest,and best way to get a count of rows in a table.
select max(rownum) from t is actually a poorer performing alternative to count(*).
|
|
|