Re: Views into tables

In article <31BD174F.365E_at_ix.netcom.com>, arenn_at_ix.netcom.com says...
>
>Joanne Woytek wrote:
>> We have a very large table (called large_table) which has a column
>> named status which has a small number of valid values, making it a
>> poor candidate for indexing. Unfortunately a large number of queries
>> and updates are done with status in the where statement. Most of the
>> rest of the queries are on well-indexed columns.
 [snip]
>

I'm still relatively new to Oracle so I'm not sure if this will help you, but I just attended a seminar at Oracle on the new features of release 7.3. One of the enhancements is bit-mapped indexes. They are used when a column has only a few possible values. One example they showed us cut a 46 second full table scan down to about 6 seconds with a bit mapped index. If you have or are planning to upgrade to 7.3 you might check this out.

Good luck,
Rona Crystal

-- 
All opinions expressed here are mine alone and do not reflect
the opinion of any other individual or organization.