Hi,

you are right, but in my opinion it does not explain why it is fast in the Management Studio (3 seconds) and slow in the reporting services (60 seconds). The execution plan displayed in the management studio shows that everything is fine and the index is used.

At the moment the report server takes always the same time (~60 seconds), with or without hint.

Regards

Oliver