Anybody a solution for the next problem:
people can subscribe to a service for 1 or more days (upto a max. of 365).
So in the database is stored: first_date and last_date
To select which people are subscribed for a certain date (e.g. today) we use
a select like
select ... where
Quoting H.J. Sanders [EMAIL PROTECTED]:
Anybody a solution for the next problem:
people can subscribe to a service for 1 or more days (upto a max. of 365).
So in the database is stored: first_date and last_date
To select which people are subscribed for a certain date (e.g. today) we use
a
On Fri, Apr 01, 2005 at 09:59:44PM -0800, Mischa wrote:
select ... where first_date = today and last_date = today
Whatever index we create system always does a sequential scan (which I can
understand). Has someone a smarter solution?
Yep, standard SQL problem. The answer is