I would like to add indexes to a couple of SQL Views in the DDT. However, when I edit the view in the DDT it doesn't detect all of the field names in the view. As a result, I can't add an index as it only allows an index to be added to a field that is detected in the view.

Is there a way around this?

Thanks,

Aaron