Re: Where clause ordering

In article <809252402snz_at_jlcomp.demon.co.uk>, Jonathan_at_jlcomp.demon.co.uk says...
>[snip]
>Who said CLASS was indexed ?
>
>My 'short-hand' above was clearly too obscure, for which I apologise,
>the phrase:
>
> "all other things being equal"
>
>should, of course have read something like:
>
> "when there are no further index-based strategies left
> for the optimiser to consider and the only remaining
> selection criteria demand a direct examination of the
> contents of the table itself"
>
>
>BTW: if you use a general purpose lookup table, of the typical
>form (class, key_within_class, value) it is _almost_ always a
>mistake to have an index that starts with CLASS.
>
>--
>Jonathan Lewis

Jonathon,
Don't be so bloody defensive just because someone pointed out the fallacy (mistake) within your original post. Your error was explained to you clearly and politely. If you can not extend those courtesies to others on this list, stop using it. Further do not assume that the readers of this newsgroup know your data, nor why you wouldn't index a column called class.

Bob Johnson
Computervision
Sydney Australia Received on Tue Aug 29 1995 - 00:00:00 CEST