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: Why this query is sooo slow?!

Re: Why this query is sooo slow?!

From: JZ <ibm_97_at_yahoo.com>
Date: 25 May 2004 07:48:32 -0700
Message-ID: <10bc841c.0405250648.2ae68572@posting.google.com>


>what does
>select num_rows from user_tables where table_name='HIGH'
>look like compared with
>select count(*) from HIGH;

THey're the same: 3797502

Thanks! Received on Tue May 25 2004 - 09:48:32 CDT

Original text of this message

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