Posted At : Nov 02, 2010 10:48 AM
| Posted By : Ed Tabara
Related Categories:
SQL
Sometime, finding records that exist between 2 dates can be slow especially when the check is done to a JOINed table as in the following example:
Select tbl1.fld1, tbl1.fld2, tbl2.fld3
From tbl1
Inner Join tbl2 On tbl2.dateFld BETWEEN tbl1.startDate And tbl1.endDate
And here is a simple way to increase the performance with a simple change:
Select tbl1.fld1, tbl1.fld2, tbl2.fld3
From tbl1
Inner Join tbl2 On tbl1.startDate <= tbl2.dateFld
Where
(
Case
When tbl2.dateFld <= tbl1.endDate Then 1
Else 0
End
) = 1
Comments (0) |
Print |
| 1480 Views
| 4% / 0% Popularity
