Re: [ADMIN] Indexing a boolean

2003-08-27 Thread Bruce Momjian
Renney Thomas wrote: > scott.marlowe wrote: > > >On Thu, 21 Aug 2003, Kris Kiger wrote: > > > > > >>I would appreciate it if I could get some thoughts on indexing a field > >>with only two values? For example, I have a table with a few million > >> > > >>Often the best approach here is to ma

Re: [ADMIN] Indexing a boolean

2003-08-22 Thread Renney Thomas
scott.marlowe wrote: On Thu, 21 Aug 2003, Kris Kiger wrote: I would appreciate it if I could get some thoughts on indexing a field with only two values? For example, I have a table with a few million Often the best approach here is to make a partial index: create index table_dx on table (

Re: [ADMIN] Indexing a boolean

2003-08-21 Thread scott.marlowe
On Thu, 21 Aug 2003, Kris Kiger wrote: > I would appreciate it if I could get some thoughts on indexing a field > with only two values? For example, I have a table with a few million > rows in it. All items in this table are broken up into two categories > using 'T' or 'F'. It seems logical

Re: [ADMIN] Indexing a boolean

2003-08-21 Thread Bruno Wolff III
On Thu, Aug 21, 2003 at 15:47:39 -0500, Kris Kiger <[EMAIL PROTECTED]> wrote: > I would appreciate it if I could get some thoughts on indexing a field > with only two values? For example, I have a table with a few million > rows in it. All items in this table are broken up into two categories