Hi All, Could you please tell me how to resolve the below warning

Hemant_Sharma

[39100] Logical column "abc."dimension"."status" has CLOB/BLOB data type but has no sort order column and/or description ID column assigned. This will cause slower query performance.

Gianni Ceresa

Assign a sort order column and/or a descriptor ID column to your logical column.

But it's just a warning, because it all depends how and where you are going to use your logical column, and based on that you will maybe never ever use the sort order column or the descriptor ID column.

If you really want to get rid of that warning, you could use an ID column being at the same logical level for the job: it will be a "simple" data type that can be sorted and queried easily.