blush! Thanks...
Having been through two books and having aborted the third, I can only
repeat what a friend told me after completing his MBA at night school: You
can work your job, live your life, and go to school. But, only two at a
time...
Substitute write a book for go to school and that
To clarify my Book! Book! Book! :)...
This is my request for Tim to write [another] one.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101 in Reykjavik, Ottawa, Dallas, Washington, Denver, Sydney
- Visit www.hotsos.com for schedule details...
Cary, I will be first one to get a copy of the book.
And now this is my turn to request Tim ;)
Book! Book! Book!
Jp.
2003/06/02 18:54:38, Cary Millsap [EMAIL PROTECTED] wrote:
To clarify my Book! Book! Book! :)...
This is my request for Tim to write [another] one.
Cary Millsap
--
Please
Tim,
First, i would like to thank U a million.
It was a real GOOD explanation.
I don't know why should you apologize for helping me.
I should be thankful to u for helping me in time.
GREAT to have guys like u in this list.
Knowing is GOOD.
but making others know it , is GREAT.
thanx for your
JP,
In the EXPLAIN PLAN, it says Card=262146, indicating that the query
expects to retrieve over a quarter-million rows. Is that in fact correct?
If so, the CBO is making the correct decision to perform a FULL table scan.
What was the comparison of elapsed times between the two plans, the one
Naveen , these parameters look to be already set
Doesn't FBI come in with 8.1.7 and Prem is on 8.16 and a comapatible of 8.10 is in
place
Failing that, as my second guess, 2 privileges need to be assigned to the user
(QUERY_REWRITE and CREATE INDEX). The 2nd one is obviously in place to allow
FBI is supported on 8.1.6 (that is what I use them on), but you may be right
about the compatible setting.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, May 29, 2003 7:46 AM
To: Multiple
Wow, there sure are a lot of Scott's in India...
-Original Message-
Sent: Thursday, May 29, 2003 9:30 AM
To: Multiple recipients of list ORACLE-L
JP,
In the EXPLAIN PLAN, it says Card=262146, indicating that the query
expects to retrieve over a quarter-million rows. Is that in fact
John,
I tried it with COMPATIBLE=8.1.6.
no nulls in that particular column
but it's the same again.
As Tim pointed out,
CARD=262146 -- as per the EXPLAIN PLAN for SELECT w/o HINT.
the SELECT retuens about 2.5 million rows.
which is why it goes for a FTS than a Index scan
is my understanding
Thanks Tim.
But the SELECT returns just 2 of 20,00,000 records.
and the Time elapsed for Index scan is 0.7 secs where as
it is 5 secs for FTS.
Hell a lot of lousy things here Tim.
just mending it one by one.
Regards,
Jp.
2003/05/29 22:30:02, Tim Gorman [EMAIL PROTECTED] wrote:
JP,
In the
AGE
whose value cannot not be found from the index.
Regards
Naveen
-Original Message-
From: Prem Khanna J [mailto:[EMAIL PROTECTED]
Sent: Friday, May 30, 2003 8:45 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: Function Based Index - Not Used ???
John,
I tried
JP,
I apologize in advance for the long email, but I think you'll find it
rewarding to read it all the way through...
The CBO is just a mathematical processor, and a rather good one at that. It
is choosing the best plan given the data it has been given, which is
admittedly often incomplete.
Wow, too good!
-Original Message-
From: Tim Gorman [mailto:[EMAIL PROTECTED]
Sent: Friday, May 30, 2003 11:00 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Function Based Index - Not Used ???
JP,
I apologize in advance for the long email, but I think you'll find
Book! Book! Book! :)
Speaking of query optimizers, here are some simple things about Oracle query
optimizers that I think a lot of people miss:
- CBO is just a module that chooses an execution plan
- RBO is another module that chooses an execution plan
- In 8.1.6+, CBO usually does a better job
Don't remember but you need a few parameters set appropriately for the FB
indexes to work.
I guess one of the parameters is QUERY_REWRITE_ENABLED which should be set to
TRUE and you also need to set QUERY_REWRITE_INTEGRITY to some appropriate
value.
Regards
Naveen
-Original Message-
Oops! didnot read your full message.
try setting OPTIMIZER_INDEX_COST_ADJ with alter session to a lower value
Regards
Naveen
-Original Message-
From: Naveen Nahata
Sent: Thursday, May 29, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Function Based Index
16 matches
Mail list logo