bpalmer <[EMAIL PROTECTED]> writes:
> - I have a query:
> SELECT stamp
> FROM table
> WHERE
> timestamp > now() - INTERVAL '1 0:00'
> This query takes 13 seconds to run.
It's probably not being indexed (use EXPLAIN to check). The problem
is that "now() - INTERVAL '1 0:00'" is not considered a
Two questions:
- Does the order of WHERE clauses make a difference? I was trying to make
some of my code faster and tried switching two clauses that should have
effected the query, but there was no speed difference.
- I have a query:
SELECT stamp
FROM table
WHERE
timestamp > now() - INTERVA
