Re: [GENERAL] Indexing strategy

On 04/17/2011 03:52 AM, Phoenix Kiula wrote: 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

[GENERAL] Indexing strategy

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%,