|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
December 12th, 2001, 08:26 PM
|
|||
|
|||
|
The fastest way to stat record count of a huge database?
Originally posted by : yukaikai (yukaikai@sina.com)A Oracle Database,about 1,000,000 records. How to use the fastest way to stat record count? I have use "seclect count(*) from Table_01",but it is very slow!any way faster? Thank you!
|
|
#2
February 28th, 2002, 03:31 PM
|
|||
|
|||
|
Originally posted by : TomTry, Select count(x) From Table_01Where x is equal to the name of primary key field.------------yukaikai at 12/12/2001 6:26:56 PMA Oracle Database,about 1,000,000 records. How to use the fastest way to stat record count? I have use "seclect count(*) from Table_01",but it is very slow!any way faster? Thank you!
|
|
#3
October 14th, 2003, 11:43 AM
|
|||
|
|||
|
SELECT Count(*)
from a 1,000,000 records table should execute in s.th. like a second if there is an index Count(*) can use. Fastest is a clustered index.
|
|
| Viewing: ASP Free Forums > Database > SQL Development > The fastest way to stat record count of a huge database? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
