Skip to Main Content

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!

peformance:nvl( my_column, 'N') <> 'Y' VS nvl( my_column, 'N') = 'N'

Peddi Kristipati-OracleMar 14 2014 — edited Mar 15 2014

Which one gives better performance? Could please explain.

1)nvl( my_column, 'N') <> 'Y'

2) nvl( my_column, 'N') = 'N'

--

Thanks

Peddi

This post has been answered by Frank Kulash on Mar 14 2014
Jump to Answer

Comments

Lothar Flatz

Would be terribly efficient.

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

Post Details

Locked on Apr 12 2014
Added on Mar 14 2014
8 comments
2,647 views