SQL & PL/SQL

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!

Index to replace regexp_like

692306Mar 23 2009 — edited Mar 23 2009

Hi I am a novice at oracle and need help in creating an index on a column that has text values. Basically, I have a requirement where I need to retrieve all records from a table where the data in a specific column begins with letter A (or B or C so on...). I was using REGEXP_LIKE till now but the performance of the query isn't good. This table has around 13500 records and this column value isn't null for any of the records.

Also, in one case I will retrieve all other rows in which the data in this column does not start with an alphabet (for e.g. beginning with a number).

Any help is much appreciated.

Thanks,
DM

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 20 2009

Added on Mar 23 2009

5 comments

1,034 views