In short words:
i am looking for a good possibility to organize the big amount of data in a way, which makes selections with a long list in the where-clause as performant as possible...
any ideas? and maybe any explanantion, why the costbased optimizer is so poor in getting the correct table within a partitioned view...
CBO has not been designed and developed to take care of "TABLE NAME" before computing the cost as you expected.

Partition View is a 20th Century technology when table partition was not available.

Are you still want to use it?

Tamil