Re: Star queries and analyse?

If 10,000 rows is only a small % of the rows in the table then the CBO may well not pick a star transformation without a hint, from experience I would recommend :

Estimate 20% and ensure you include histograms on the bit mapped index.

Regards
David Russell

Steve Haynes wrote in message ...
>Hi All,
>The cost based optimiser needs to know the
>relative size of tables
>(and have star_transformation_enabled=true or star hint I believe).
>My question is that if you only estimate 10000 rows (less than actual)
>then the optimiser won't reconise it as a fact table.
>Does that mean you should estimate 50% or so on the fact table?
>Steve
>--
>"The floggings will continue until morale improves."
>
Received on Sat Jun 06 1998 - 18:12:43 CDT