Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

To make select query without index faster

944524Dec 22 2015 — edited Dec 22 2015

Hi,

Is there a way to make the select query faster without creating index on the column , table something like this

select * from T1 where col_1 = to_date(01-01-1988,'DD-MON-YYYY');

T1 has millions of records

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 19 2016
Added on Dec 22 2015
8 comments
1,474 views