Re: Need a Fast Row Count
From: <jumaga_at_my-deja.com>
Date: 2000/03/23
Message-ID: <8bds8h$gcb$1_at_nnrp1.deja.com>#1/1
Date: 2000/03/23
Message-ID: <8bds8h$gcb$1_at_nnrp1.deja.com>#1/1
If there is an index on the table, instruct oracle to count the nodes in the index by providing a hint:
select /*+ index(table_name) */
count(*) from table_name;
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Mar 23 2000 - 00:00:00 CET