problem in to_date function

hi
i have a table c_table with two columns no,
date
it contains records

no n_date
1 10-AUG-03
2 21-AUG-03 when we issue
select * from c_table where n_date='10-AUG-03'; it will successfully return the record

but when we give
select * from c_table where n_date='21-AUG-03';

it will not return the record

after using to_date function like
select * from c_table where to_date(n_date,'DD/MM/YY')='21/08/03';

it will successfully return the records
but the main problem is that
when we have table that contains 50,000,00 records **and then using to_date function then it will slow down the performance

how we can solve the. Received on Sat Aug 23 2003 - 06:45:20 CEST