From: Ad 


> So, my quesstimate would be somewhere between "very little"
and "dick all".
>

Yup, the "table scan" is the killer.

indexing is the biggest perf gain you can do. I have worked on numerous
db'es which had no keys (fk or pk) & only had indexes.

Adam

--- BBBS/NT v4.01 Flag-5