Richard Huxton writes:
> George Woodring wrote:
>> FROM
>> settop_billing
>> LEFT OUTER JOIN
>> (dhct JOIN dhct_davic USING(mac))
>> USING
>> (mac)
>> WHERE
>> region='GTown1E' AND node='1E012'
> With 7.4 I seem to remember that explicit JOI
George Woodring wrote:
explain analyze SELECT column1, column2, column3, column4, column5,
column6, column7, column8 FROM (SELECT CASE status WHEN 0 THEN 0 WHEN 1
THEN 1 ELSE -1 END AS column1, mac AS column2, account AS column3,
number || ' ' || address AS column4, 'qmod' || '.' || 'dmod' AS c
I am running 7.4.8 and have a query that I have been running for a while
that has recently have experienced a slowdown. The original query
involves a UNION but I have narrowed it down to this half of the query
as being my issue. (The other half take 4 seconds).
The only issue that I have had is
