The database is 10.2 on RHEL 3.
I have a table on which I have 2 indexes, one normal and one function-based.
The different queries I run are
select count(*) from t1 where username='user1'; and select count(*) from t1 where lower(username)='user1';
the index are created with
create index f_t1_username on t1(lower(username)); create index uq_t1_username on t1(username);
Wolfgang Breitling Centrex Consulting Corporation www.centrexcc.com -- http://www.freelists.org/webpage/oracle-l