>>Thanks, I'll try to run some tests, but so far they were non conclusive.
>
>I didn't look closely at your select but are all those JOINs for filtering result set or for retrieving additional fields?
Some are for filtering results and some are for additional fields. E.g. join to Users table is to get cUserID field. Same story is with cUsGrLink field (join to UsGrLink table). Essentially I don't need these joins and can do them after I get my result.
If it's not broken, fix it until it is.
My Blog