Re: force use of an index - how to?

In article <798052356snx_at_kbigate.stgt.sub.org> willyk_at_kbigate.stgt.sub.org (Willy Klotz) writes:
>Path: news.teleport.com!psgrain!reuter.cse.ogi.edu!uwm.edu!math.ohio-state.edu!jussieu.fr!univ-lyon1.fr!swidir.switch.ch!scsing.switch.ch!news.belwue.de!news.belwue.de!delos.stgt.sub.org!aragon.stgt.sub.org!kbigate!willyk
>From: willyk_at_kbigate.stgt.sub.org (Willy Klotz)
>Newsgroups: comp.databases.oracle
>Subject: Re: force use of an index - how to?
>Distribution: world
>Message-ID: <798052356snx_at_kbigate.stgt.sub.org>
>References: <odysscci.323.0015F303_at_teleport.com>
>Date: Sun, 16 Apr 95 17:12:36 GMT
>Organization: None
>Lines: 33

>odysscci_at_teleport.com writes in article <odysscci.323.0015F303_at_teleport.com>:
>>

<snip>

>Try using a where-clause like "where lastname > ' '.
 

>Index use is driven by he where clause, not by the order clause.
 

>Regards
 

>Willy Klotz
 

>======================================================================
>Willys Mail FidoNet 2:2474/117 2:2474/118
> willyk_at_kbigate.stgt.sub.org VFC ISDN/X.75
> -> No Request from 06.00 to 08.00 <-
>======================================================================
Thanks everyone for their posts. I found that where lastname>' ' works unless you want to include the situation where lastname is NULL. So the debate moved to "Now is Madonna a lastname or a first name..." (i.e. do people always have last names.) I can live with that. And yes, I reached the conclusion that index use is driven by the where clause and not the order by clause - seems silly, but that's the facts.

Thanks everyone,
Jim Kennedy Received on Thu Apr 20 1995 - 00:00:00 CEST