Received: from smtp-1.attica.net.nz (pop3-1.attica.net.nz [202.180.66.199]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6IN2Ha23201 for ; Wed, 18 Jul 2001 19:02:18 -0400 (EDT) (envelope-from markir@slingshot.co.nz) Message-Id: <200107182302.f6IN2Ha23201@postgresql.org> Received: (qmail 62678 invoked from network); 18 Jul 2001 23:02:12 -0000 Received: from mail.attica.net.nz (HELO Debug) (202.180.64.33) by pop3-1.attica.net.nz with SMTP; 18 Jul 2001 23:02:12 -0000 To: , Mark kirkwood , From: Subject: Re: How Postgresql Compares For Some Query Types Date: Wed, 18 Jul 2001 23:02:12 GMT X-Mailer: Endymion MailMan Professional Edition v3.0.33 X-Archive-Number: 200107/254 X-Sequence-Number: 4051 > > 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 : observations, accidents, sales .... facts have a composite primary key , each componant of which is a foreign key for one of the dimensions. If drawn with the fact table(s) in the center and dimensions around about, then the ERD looks like a "star". Hence the names "star schema" and "star query" A quick search located a vaguely helpful page : ( apologies about the source ) http://www.oradoc.com/ora816/server.816/a76994/schemas.htm A much better source is Kimball's book "The Data Warehousing Toolkit". regards Mark