Re: Checking for the existence of a certain row.

[Michael A. Chase]

----- 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.