Title: RE: Oracle 9.2.0.5 CBO Not Using Index
**
Axton:
I'm talking about archiving to a historical record form rather than using partitioning within the data table for one form. Makes searches run faster/better when your users forget to select 'status' <= "Resolve
Axton
Sent: Thursday, May 04, 2006 7:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle 9.2.0.5 CBO Not Using Index
I can find nothing on the net to confirm your statements. The closest thing
I can find that relates to this is the list of the "20 golden rules" of the
oracle RBO.
http:/
Title: RE: Oracle 9.2.0.5 CBO Not Using Index
**
Axton:
Partitioning is a fantastic feature and should be employed where it can. However, BMC did not decide to use this feature out of the box. I would help greatly if you could partition a high use form, such as the Help Desk Case, by
000 entries. Does anyone want
to confirm/deny that this is the case?
James McKenzie
L-3 GSI
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Wednesday, May 03, 2006 4:54 PM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle 9.2.0.
Title: RE: Oracle 9.2.0.5 CBO Not Using Index
**
Jon:
Do you have an index on the field and is the field set to equals or leading in the QBE?
I forgot those two. If the QBE setting is ANY, then the query sent to Oracle will automatically have the Wildcard (%) character added to the front
I also saw that in the PT&T training manual that I have, but it didn't
make a difference when I tried. Thanks for the suggestion Axton, I
will let you know how it goes.
On 5/4/06, McKenzie, James J C-E LCMC HQISEC/L3
<[EMAIL PROTECTED]> wrote:
**
Axton:
That was directly from the PT&T class a
Title: RE: Oracle 9.2.0.5 CBO Not Using Index
**
Axton:
That was directly from the PT&T class and was enforced by some basic ORACLE training that I received.
Here is gist of the training:
If the query can be closed end (i.e. equals) then the optimizer will look to see if the index
L PROTECTED] On Behalf Of Jon Chau
Sent: Wednesday, May 03, 2006 2:30 PM
To: arslist@ARSLIST.ORG
Subject: Oracle 9.2.0.5 CBO Not Using Index
Hello Listers,
I've read some past threads on Oracle CBO optimization and database
tuning and have been having a constant battle with my DBA on how to
re
Title: RE: Oracle 9.2.0.5 CBO Not Using Index
**
Jon:
Your problem is using the < sign. This forces Oracle to check EACH and EVERY entry in the table. Try this:
'Status' <= "Pending"
This should use the index as you are now looking for a value that ha
Hello Listers,
I've read some past threads on Oracle CBO optimization and database
tuning and have been having a constant battle with my DBA on how to
resolve the issue we are having. We have a HelpDesk form with an
index against the Status field and it is not being used when we are
using a rang
10 matches
Mail list logo
