Re: tom kyte reference to build an index

gcherer_at_texas.net wrote:
> In Tom's expert oracle database architecture book, i got stumped on
> page 7. He uses this sentence: "Create an index only on the
> processed_flag column when the processed_flag is N...". i am stumped
> on how to make an index on a column but only for certain values. In
> this case, the 'processed_flag' only has two values - N or Y. He is
> talking about creating an index only on the N values, which are
> relatively few and are the only rows of interest.
> So, the inexperienced idiot (me) asks, how the heck do you build an
> index only on a column with certain values??
> Please be gentle in your reply.
> TIA
For a demo showing this go to www.psoug.org click on Morgan's Library
click on Function Based Indexes

There is a demo there, with Tom Kyte's name next to it, that shows how to do this.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)