Viewing 2 posts - 1 through 3 (of 3 total)
Thanx GRN,
A composite index indeed might help!
About putting an index on "Country" in table "Customer" (in our case "Type" in table "Utility"), we don't do that really if the...
X
December 2, 2003 at 6:56 am
#484267
I would guess that by putting
select DISTINCT DD.fk_intDocumentID ,DD.fk_intUserID
from dbo.tbl_DocumentDownloads DD
where ......
in a view and than counting the number of records in the view would be cleaner and faster...
December 2, 2003 at 5:34 am
#484242