Hi, Need some help here. I have a large table (200 million rows already). There are two columns. ColA ColB There is an index on ColA. It's an important column. ColB is a boolean. Either 1 or 0. For about 10% of the data, ColB is 1. Otherwise it's default is 0. Now, my question: for that 10%, is it worth adding a conditional index on "ColA WHERE ColB = 1"? Will this save time for the queries that are related to 10% of my data where the ColB is 1? Or will the main leading index on ColA already speed things up as much as it can? Thanks for any ideas! PK -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
