Post reply

Should I index money column?

  • December 1, 2006 at 12:39 pm

    #118230

    I almost always calculate $ totals when I query that table

  • December 1, 2006 at 1:08 pm

    #675260

    Depends on the queries you hit the table with...

    It can be usefull if you do something like :

    Select OrderID, SUM(LinePrice) AS TotalBeforeTaxes FROM OrdersDetails WHERE OrderID BETWEEN 100 AND 200 GROUP BY OrderID

     

    But the index wouldn't be used by a lot of other queries... but that's without knowing your system so don't take my word for it .

  • December 1, 2006 at 1:28 pm

    #675273

    Indexing the money fields would only make sense if your queries are selecting on those fields.  For instance, you are looking for all products in inventory with a unit price between $75.00 and $125.00.

     

  • December 1, 2006 at 1:32 pm

    #675276

    Yup or in a covering index... as in my exemple!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply