Hi, Adam

<Quaoted>
Generally no.

There are exceptions if the field values are skewed. For example, if 99% of the values are 'Y', and only 1% are 'N', then the index would
be very useful to perform where field = 'N'.
<Quaoted>

what if using where field <> 'N' or where field = 'Y', will the index be used?

Thanks, Much appreicated.

William


William, Yu


---------------------------------
Brings words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.

[Non-text portions of this message have been removed]