>The biggest issue you have is non-indexed queries. There are things you can do there to speed up this stuff, such as retrieving a subset using the index, then querying the intermediate table.

Craig,

You said "...retrieving a subset using the index..." What do you mean exactly?

Renoir