Re: SQL Tuning

On Sun, 06 Jul 2003 21:53:57 GMT, Hans Forbrich <forbrich_at_telusplanet.net> wrote:

>Daniel Morgan wrote:
>
>> I couldn't agree less.
>>
>> The CBO's decisions are intelligent and if you learn how it works, and use
>> hints, blows away the performance of the RBO.
>
>I think there is an exception to the above statement. You are making the
>assumption that the developer is actually capable of [thinking and] leveraging
>some of the non-simplistic features of the RDBMS.
>
>In my experience, the majority of developers are not aware of things like
>bit-mapped indexex, function indexes, bitmap-join indexes, partitioning, IOTs,
>etc. Most still want to reinvent stuff like intermedia & context and auditing.
>(Support for this - look at how many 'features' like XA & constraints they are
>trying to introduce at the development language level.) Thus they still tend to
>design and code like we did in the 1980's - in which case the RBO *may* still be
>valid.

You are right I am a developer and have not really studied bit-mapped indexex, function indexes, bitmap-join indexes, partitioning, IOTs etc because I am developing. I feel real guilty about that and try to do someting about it. I actually had to partially reinvent intermedia as the first version of it was not mature enough so you are right again. Fortunatelly intermedia is now mature enough but it took its time again and it was too late.

Again to the other 4 people:
Let just say I am just a simple soul with a small mind who thinks too much for other people. Received on Mon Jul 07 2003 - 23:26:48 CEST