indexes

From: Infor-med <informed_at_sminter.com.ar>
Date: Thu, 15 Apr 1999 10:44:48 -0300
Message-ID: <924184174.432.26@news.remarQ.com>

I do
select id from patientrec where patregnum like initcap('a%') or lastname like initcap('a%');

I have an unique index on patregnum and an index on lastname. This take longer time than the following both two sentencies. select id from patientrec where patregnum like initcap('a%'); select id from patientrec where lastname like initcap('a%');

Sergio. Received on Thu Apr 15 1999 - 08:44:48 CDT