Sybase Error – The option ‘Revert_To_V15_Optimizer’ is not supported for queries involving RLV enabled tables

In this blog post, you’ll learn more about the Sybase Error The option ‘Revert_To_V15_Optimizer’ is not supported for queries involving RLV enabled tables and the reason for receiving this error

Sybase SQL Error Message

The option ‘Revert_To_V15_Optimizer’ is not supported for queries involving RLV enabled tables

Reason for this Error

Pre-Elan optimization is used with revert_to_v15_optimizer option, query tree creation itself does not allow it if table is RLV enabled.