Re: [Q]: Indexes with LIKE clause

From: Lawrence James <James.Lawrence_at_epamail.epa.gov>
Date: Mon, 21 Nov 1994 15:56:48 GMT
Message-ID: <James.Lawrence.17.000FF2D2_at_epamail.epa.gov>

In article <39mjll$fni_at_s.ms.uky.edu> neil_at_ms.uky.edu (Neil Greene) writes:
>From: neil_at_ms.uky.edu (Neil Greene)
>Subject: [Q]: Indexes with LIKE clause
>Date: 7 Nov 1994 20:18:44 -0500
>Keywords: index, oracle

>What ill effects does the use of a LIKE clause have with respect to
>index performance, if any??

>-- Neil

If the wildcard is in the front it will disable index usage, if it is on the back or middle the index will be used up to the wild card.

Lawrence.... Received on Mon Nov 21 1994 - 16:56:48 CET

This message: [ Message body ]
Next message: Lee E Parsons: "Re: "Hung" Select bug in 7.0.X"
Previous message: Byron Pearce: "Primary Key vs. UQ Index"
In reply to: Neil Greene: "[Q]: Indexes with LIKE clause"
Next in thread: Lee E Parsons: "Re: "Hung" Select bug in 7.0.X"
Reply: Paul Zola: "Re: [Q]: Indexes with LIKE clause"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message