Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: count(*) very very slow with few records ?
Hello
do : count(id) /* <id> is the prime key of table */
this should be faster,
Is your blob in a seperate tablespace or inline?
Bye
/Karl
Karl Reitschuster
Senior Consultant CSC Ploenzke AG
Oracle Databases, Implementation, Performance-Tuning
<!Jesus is Lord!>
* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!
Received on Thu May 04 2000 - 00:00:00 CDT