> -----Original Message-----
> From: Michael A. Chase [mailto:[EMAIL PROTECTED]]
> Sent: 08 July 2001 03:51
> To: Steve Howard; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Checking for the existence of a certain row.
>
>
> ----- Original Message -----
> From: "Steve Howard" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Saturday, July 07, 2001 19:47
> Subject: RE: Checking for the existence of a certain row.
>
>
> > (I'm installing Oracle on Solaris right now. I'm anxious to
> get my hands
> on
> > it. I've only been off of mainframes for a couple of years,
> and haven't
> used
> > it, but hear some interesting things, like trim() in the
> where clause
> causes
> > indexes to not be used, and count causes a table scan. I'm
> sure it's all
> > accurate, but it certainly poses some challenges I've never
> thought about
> > having to deal with).
>
> Any function around a column in the WHERE clause takes it out
> of the running
> for using it with an index. On the other hand, as long as
> you can avoid
> CHAR columns, you shouldn't need to TRIM() a column for
> comparison. There
> is also no case-insensitive comparison.
Although, if you're installing a fairly recent Oracle, you can build indexes
on functions...
--
Dan Hopkins
