RE: statement tuning ?
- From: Ken Naim <ken@xxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 1 May 2004 23:16:35 -0400
I have seen tremendous improvements using the CBO and analyzing all tables
in a Siebel database.
While using the RBO our OLTP type queries were measured in minutes and after
analyzing and using the CBO, execution time dropped to several seconds; a
30-60 fold increase in performance. Our key tables S_Contact, S_contact_x
drove most of the queries and had approximately 4 million records.
Once we were on the CBO we felt our hands were untied and we started to add
function based indexes for case insensitive searches, partitioning etc so
our execution time for most queries became sub-second. Analyzing Siebel's
EIM_* data load tables decreased load times by an order of magnitude when
dealing with hundreds of thousands to millions of records.
Siebel was not happy to say the least and they said they wouldn't support
us, my company decided such a performance gain was worth canceling support
so we got the performance increase and saved ourselves a lot of cash at the
same time.
Ken Naim
-----Original Message-----
From: David Green [mailto:thump@xxxxxxxxxxxxxxxx]
Sent: Saturday, May 01, 2004 3:20 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: statement tuning ?
Tim, thank you very much...I will look into your suggestions further!
- David Green
-----Original Message-----
From: Tim Gorman
Sent: Saturday, May 01, 2004 1:47 PM
Subject: Re: statement tuning ?
David,
I figured I might as well respond according to expectations and respond =
with
a short novel... :-) My apologies in advance for my deplorable lack of
brevity...
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
