Re: Does != use index ???

From: Tim Witort <trwNOSPAM_at_NOSPAMmedicalert.org>
Date: 1997/08/28
Message-ID: <34060AE7.168E@NOSPAMmedicalert.org>#1/1

Ronak Bhatt wrote:
>
> Hi,
>
> Does the operator " != " make use of existing index ?????

If the column on one side of that "!=" is indexed, yes.

TRW -- ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | Tim Witort || He is not silent. He is not | | trwATmedicalertDOTorg || whispering. We are not quiet | | || we are not listening. | | Pin: TZ, only one :^( || - Out of the Grey | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

Received on Thu Aug 28 1997 - 00:00:00 CDT