Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: count(*) very very slow with few records ?

Re: count(*) very very slow with few records ?

From: Karl R. <kreitsch_at_zdnetonebox.com>
Date: 2000/05/04
Message-ID: <18584a99.58787468@usw-ex0101-008.remarq.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US