Re: Low cardinality in OLTP with high concurrency

From: Phil H <>
Date: Wed, 25 Mar 2009 14:18:51 -0700 (PDT)
Message-ID: <>

If the column you're selecting against doesn't change often, you can try partitioning the table on that value or its hash. That will mean that your queries will scan 1/16th of the table (on average) and won't need an index. Of course, this will only help if the values aren't highly skewed.

There may be some other things you can try. It would help if you provided more information about the table in question.

  • Phil
Received on Wed Mar 25 2009 - 16:18:51 CDT

Original text of this message