Re: [SQL] Different Choices For Index/Sequential Scan With And Without A Join In 7.2

2001-08-26 Thread markir
> Mark kirkwood <[EMAIL PROTECTED]> writes: > > Note that 'f1' = '2000-01-26' corrosponds to 'd0key' = 270 in the table > > 'dim0'; > > What do you mean by "corresponds to"? Is there a one-to-one mapping > between distinct values of fact0.d0key and distinct values of dim0.f1? > Or do you jus

Re: [SQL] How Postgresql Compares For Some Query Types

2001-07-18 Thread markir
> > I'm a little unclear on what a "fact table" is. Can you explain? Good question... The idea comes from data warehousing where a typical data construction involves two "types" of table : dimensions : time, location, ethicity( essentially denormalized lookups ) facts : observ