Star Query Indexes
From: Mike Rushton <mike_at_mrush.demon.co.uk>
Date: 1996/11/02
Message-ID: <327b6579.28920154_at_news.demon.co.uk>#1/1
Mike Rushton | "A greate many open minds mike_at_mrush.demon.co.uk | should be closed for repairs"
Received on Sat Nov 02 1996 - 00:00:00 CET
Date: 1996/11/02
Message-ID: <327b6579.28920154_at_news.demon.co.uk>#1/1
I am a little puzzled at how to implement indexes on a table which is the central table in a Data Mart with approximately 10 associated dimension tables.
I am using Oracle 7.3.2.1.0 and the documentation states that
"The cost-based optimizer intelligently searches for potential star queries based on two criteria.
- One table is significantly larger than any other table in the query
- The larger table contains a concatenated index"
Please help my confusion
Mike Rushton | "A greate many open minds mike_at_mrush.demon.co.uk | should be closed for repairs"
Received on Sat Nov 02 1996 - 00:00:00 CET