Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> tom kyte reference to build an index
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
Received on Tue Dec 13 2005 - 17:57:36 CST