Christian,
please show us table, index and view definitions (you may remove irrelevant
columns) as well as the sql in question and an approximate number of
records in each table/view.

Set