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

Lothar Flatz

Would be terribly efficient.

1 - 1

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 12 2014

Added on Mar 14 2014

8 comments

2,647 views

SQL & PL/SQL

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

Comments

Post Details