no arguing with empirical evidence. What DBMS? -----Original Message----- From: Raster, Tim [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 22, 2005 1:50 PM To: SQL Subject: RE: between
I ran a test here on a 2 million row table running several hundred iterations per run. I found no statistical significance for using "between" versus "<>" operators. (p=0.626) Indexed or not doesn't seem to matter either. I would bet that most query parsers/planners basically turn the between in a >= <= in the end run, so they're basically the same. My Run Results (unindexed=50 runs, indexed=1000 runs): ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2143 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
