Re: star transformation taking too long

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Mon, 19 May 2003 09:47:26 GMT
Message-Id: <pan.2003.05.19.09.47.26.273875@adelphia.net>

On Mon, 19 May 2003 09:30:56 +0100, Jonathan Lewis wrote:

> You are not getting a star_transformation path.
> This may be the result of the 'IN' clauses that
> appear in the query.

That, besides the questions I asked above, might also be a reason. I have to confess that all my databases are OLTP and that I don't know much about the star transformation. My boss would probably have me committed if I suggested bitmap indexes in an OLTP database (4000+ concurrent users on 4xHP 9000/N OPS configuration)

-- 
Mladen Gogala
Software is like sex, it is better when it is free.
Linus Torvalds

Received on Mon May 19 2003 - 04:47:26 CDT