Re: Need URGENT HELP on PL/SQL
From: <bonanos_at_yahoo.com>
Date: Tue, 20 Apr 1999 06:09:28 GMT
Message-ID: <7fh5mj$sni$1_at_nnrp1.dejanews.com>
Date: Tue, 20 Apr 1999 06:09:28 GMT
Message-ID: <7fh5mj$sni$1_at_nnrp1.dejanews.com>
> The use of LIKE also prevents the use of an index, The way I get around that
> for a leading LIKE is to do something like this:
> ID >=' SYS' and ID <='SYS~' (The ~ is the last ASCII character, so any
> printable character is less than or = to this.) Now for the NOT LIKE... I'll
> leave that up to you...
Like uses and index if you ony have a trailing %. It only ignores the index if you put a % in front
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 20 1999 - 08:09:28 CEST