Re: SQL EXPERTS ONLY
From: Jeff Crew <jcrew_at_denadm.ms.ch2m.com>
Date: 1996/08/01
Message-ID: <4tr8p6$bsq_at_ds9.ch2m.com>#1/1
Date: 1996/08/01
Message-ID: <4tr8p6$bsq_at_ds9.ch2m.com>#1/1
Its my feeling that it is still easier to do record counts on a table by forcing the count to come from an index. SELECT count(*) FROM Customers
WHERE Customer_Name >= '0';
Getting num_rows from user_tables would work but how many people remember that it is in user_tables? Stats from an analyze may not be accurate if the table is really huge or if the analyze is not current. Its much easier to force the index to count !! Received on Thu Aug 01 1996 - 00:00:00 CEST