[prev in list] [next in list] [prev in thread] [next in thread] 

List:       odtug-sqlplus-l
Subject:    Tuning Query :: Statistics
From:       "Barry Chase" <bchase () humana ! com>
Date:       2003-08-12 21:52:02
[Download RAW message or body]

Responses from the list servers has made statements that my CBO costs are
higher than what they are getting....

We are running with an HRMS population of 20k.

What percent is your gather schema statistics for the HR schema ?




====================================================
--
--
   Barry Chase

   Consulting Systems Engineer

   HR Payroll Production and Support

   Louisville, KY
   RVS3
--
--
   email : bsc7080mqc@mylxhq.com
   MylxHQ - Oracle Resource Portal   [ oracle.mylxhq.com ]
--
--
   PLSQL solutions for FTP'ing and Emailing files via UTL_TCP
   and more.
--
--
====================================================








The information transmitted is intended only for the person or entity to which it is \
addressed and may contain CONFIDENTIAL material.  If you receive this \
material/information in error, please contact the sender and delete or destroy the \
                material/information.
-- 
Thanks to everyone for making ODTUG 2003 a great success!  See you in 2004!
If you want to volunteer for a committee, visit http://www.odtug.com
-- 
Author: Barry Chase
  INET: bchase@humana.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic