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!

Multiple Columns vs Like Operator

1012994Oct 6 2013 — edited Feb 17 2015

Hi,

The performance is very important for my application, so I need to know what is more expensive:

- Use 18 numeric columns, and query using multiple OR operators.

- Use 1 text column, and use the LIKE operator.

Can create indexes to improve performance in both cases?

Thanks!

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 3 2013
Added on Oct 6 2013
0 comments
898 views