Hi,

> Prior to the last email I explained what the static's were and how I got 9
> million fetches and it boils down to how the query optimizer is optimizing
> the plan on a left join.
>
>
>
> If a view could take parameters I would use a view but this is dynamic
> report data and hard coding dates is not an option with 5,000 users.

But you can apply a new WHERE clause to a View without problems.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com