[GENERAL] index not used?

2004-10-20 Thread Dan Pelleg
.00 rows=1 width=14) Filter: ((col = 1) AND ("row" = 10)) What am I doing wrong? -- Dan Pelleg ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] index not used?

2004-10-20 Thread Dan Pelleg
Scott Marlowe writes: > On Wed, 2004-10-20 at 08:06, Dan Pelleg wrote: > > I'm trying to access a table with about 120M rows. It's a vertical version > > of a table with 360 or so columns. The new columns are: original item col, > > original item row, and the

Re: [GENERAL] index not used?

2004-10-20 Thread Dan Pelleg
Scott Marlowe writes: > On Wed, 2004-10-20 at 09:45, Dan Pelleg wrote: > > Scott Marlowe writes: > > > On Wed, 2004-10-20 at 08:06, Dan Pelleg wrote: > > > > I'm trying to access a table with about 120M rows. It's a vertical version > >