Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Last-Date performance issues

    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...

  • RE: an ugly way of counting

    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...

Viewing 2 posts - 1 through 2 (of 2 total)