sqlplus vs pl/sql

[kris123]

Yes dear, i tried also ...
where departure_date>to_date('31-DEC-2004','DD-MON-YYYY')
and same poor performance i got.

I did not create an index on the departure_date coz of its low
cardinality and we only query by fullname. Its primary purpose
is to group the departure table by year.

What puzzled me is that does sqlplus and pl/sql have different
costbased optimizer interpretation?

I also observed that if i used the partition for searching
with the global indexed FULLNAME it will not use the index too.

example1: (this uses the global index FULLNAME)
select surname,firStname from departure_all
where ((fullname like 'TOM%WELLING%') or (fullname like 'WELLING%TOM%'))
and departure_date>'31-DEC-04' and rownum<2;

example2: (this does a full table scan)
select surname,firStname from departure_all partition(depart2005)
where ((fullname like 'TOM%WELLING%') or (fullname like 'WELLING%TOM%'))
and departure_date>'31-DEC-04' and rownum<2;