Re: Too many rows reported for index in tkprof

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx
  • Date: Wed, 10 Aug 2005 12:11:26 -0600

Actually don't use either - use create/rebuild index ... compute statistics;

You get the statistics "for free" as part of the index creation or rebuild. In oracle 10 that's even the default.

Mercadante, Thomas F (LABOR) wrote: 
Probably should have used "analyze"  :O


A trivial, but important question is whether you
analyzed the index after creating it?



        Sure, with DBMS_STATS.


--
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2005