Viewing 2 posts - 1 through 2 (of 2 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...
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