field equal to OR between 2 fields?
Hi, I have a record table that is expected to see past 500,000 in a year or 2.
Among the fields are these 3, 'start' (date) and 'end' (date) and 'type' (int).
I'd like to check if a date matches between the 'start' and 'end' fields, as it would be the easy way out for the rest of the application, but would matching to 'type' be much quicker? or no real difference?
I guess what I'm asking is, how much difference in speed or efficiency is there between these two queries:
SELECT * FROM `records` WHERE `type` = 1
and
SELECT * FROM `records` WHERE `start` <= '2010-06-01 14:50:20' AND `end` >= '2010-06-01 14:50:34'
Jason
Subject
Views
Written By
Posted
field equal to OR between 2 fields?
4378
September 11, 2009 03:48AM
5240
September 12, 2009 09:03AM
2275
September 12, 2009 11:40PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.