om> cc: <[EMAIL PROTECTED]>
Fax to:
6-15'
AND factable.Date < '2004-06-22'
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 3:16 PM
To: David Perron
Cc: [EMAIL PROTECTED]
Subject: Re: Using date ranges on a composite key degrades performance
Are you usin
om> cc:
Fax to:
06/22/2004 02:46 Subject: Using date ranges on a
composite key degrades performan
Im finding that when I execute a query joining to a large fact table (~450
million rows) using a composite key of INT(11) & DATE for a single Date i.e.
AND dimension.id = factable.id
AND factable.Date = '2004-06-22'
the query returns exceptionally fast. However, when I change this to a
range, i
