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 on string column with uppper?

MateuszHFeb 4 2016 — edited Feb 5 2016

Hello,

I have table with string primary key column. I want create index on primary key and another column.

Better solution(in respect of performance) will be create index using upper like

ON TABLE (UPPER("ID"), ANOTHER_COLUMN)

or without UPPER

Best regards,

This post has been answered by AnnEdmund on Feb 5 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 4 2016

Added on Feb 4 2016

11 comments

1,453 views