Post reply

Do indexes help tables with large number of columns but small number of records?

  • August 13, 2012 at 3:28 pm

    #280253

    I am under the assumption that indexes help you find particular records based on hashing on a combination of 1 or more columns. If this is the case, then a large table with a lot of columns but few records will not benefit much from indexes. Is this correct?

  • August 13, 2012 at 3:34 pm

    #1525311

    guerillaunit (8/13/2012)

    I am under the assumption that indexes help you find particular records based on hashing on a combination of 1 or more columns. If this is the case, then a large table with a lot of columns but few records will not benefit much from indexes. Is this correct?

    Yes it is.

    Maybe a little gain, but negligible. The B-tree will be small and regardless of the number of columns (max = 1024) the search will be very fast.

    You'd better have at least one index in cases you use that table in long-chain joins.

    Regards,

    IgorMi

    Igor Micev,My blog: www.igormicev.com

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

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