On Tue, Apr 8, 2014 at 6:39 AM, Shaun Thomas <stho...@optionshouse.com>wrote:
> > > Other possibly relevant pieces of information... The entity type > > column has a cardinality in the neighborhood of a couple dozen. > > Meanwhile, for some of the entity types there is a large and ongoing > > number of events, and for other entity types there is a smaller and > > more sporadic number of events. Every now and again a new entity > > type shows up. > > With that as the case, I have two questions for you: > > 1. Why do you have a low cardinality column as the first column in an > index? > Because if he didn't have it, the planner would never be able to use it. Remember, the problem is when the planner chooses NOT to use that index. Cheers, Jeff
