Re: Question re indexes

Sybrand Bakker wrote:
> Yes, the index will be used.
> As to the second question: I would consider lack of transparency and loosing
> control. Of course system is a special case as this user has create any
> index privilege. But wouldn't think if you grant other users the right to
> create an index all sort of unpredictable things would occur. It is a known
> fact the (especially the rulebased) optimizer often chooses an incorrect
> index when there are many different indexes on a table. I wouldn't allow the
> situation you describe, I would consider this as loosing control on my
> database.

I agree with you wholeheartedly. Unfortunately by the time I'm called into to consult because of database issues/problems the system has already been designed and I have to clean up the mess that others have created because they didn't call me first. I'm basically in a position where I have to accept the reality that I have to play a fixit role rather than a designer role.

What I will probably end up doing is dropping the offending indexes and recreating them in the proper tablespace and the proper schema, but even with that I'll have to negotiate downtime since the system is already in production. Received on Wed Apr 19 2000 - 00:00:00 CDT