Re: Star Query Indexes

From: Larry Monack <lmonack_at_sprynet.com>
Date: 1996/11/14
Message-ID: <01bbd226$736af440$8061afce@larrym>#1/1

Your points are well taken. But, can you concantenate a bitmapped index and will Oracle's optimizer recognize it for 'star' query optimization? Also, my users' front-end tools don't have the capability to imbed hints and even if they did, the users shouldn't have to.

> How many columns with high-cardinality are you looking at in a single
> query. Do most queries involve perhaps one or two high-cardinality
> dimensions (customer and/or product). Most of the other dimensions are
> low-cardinality (age group, income band, race, gender, etc.)?
Received on Thu Nov 14 1996 - 00:00:00 CST