Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Episode 2: the EntMgr Green Light!!

Re: Episode 2: the EntMgr Green Light!!

From: Joel Garry <joel-garry_at_home.com>
Date: 10 Nov 2003 13:12:36 -0800
Message-ID: <91884734.0311101312.62f77f01@posting.google.com>


domenicg_at_hotmail.com (Domenic G.) wrote in message news:<c7e08a19.0311081244.7f0acdb_at_posting.google.com>...
> Niall,
>
> Thanks for your input. I have a few questions ...
>
> What is the purpose of a reverse-key index then? Surely the guys at
> Oracle who can actually see inside the code know more than us?
>
> I'm only doing what Oracle taught me to do. They should know their
> product. Are you saying they're wrong?
>
> Sometimes DBAs have nothing to do. At least by doing these things, I
> feel like I'm being proactive, even if the benefit is negligible or
> none. Besides, the system is idle overnight, so why can't I schedule
> these rebuilds? -- they're not locking anybody out or doing harm.
>
> Wouldn't a more compact index reduce I/O? In university, I wrote C++
> code to implement b-tree indexes and I'm not sure what you're saying
> is true. The index is always better organized when it is rebuilt by
> scanning all the data in the table. It depends on the datatype and
> the exact methodology. So while I do understand your point, my point
> is this -- without actually looking inside a block or seeing Oracle's
> code, you're guessing as much as I am. I'm just following their
> recommendations, and that's all I can do since their source is not
> open.

So look inside blocks!

jg

--
@home.com is bogus.
http://www.signonsandiego.com/news/uniontrib/mon/news/news_1n10poet.html
Received on Mon Nov 10 2003 - 15:12:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US