I suffer from poor vim performance when using Vorax to work with sql files with complex queries.
I tried to disable vorax and edit the same file -- working as usual vim with instantaneous response.
I tried to create new non-sql file with the same content -- working as usual vim with instantaneous response.
I did not mention this strange behaviour previously but now it feels frustrating.
What can cause it? Maybe there is some syntax analyser which checks statement at every move?
SELECT a.dummy as dummy, a.dummy as dummy, a.dummy as dummy, a.dummy as dummy, a.dummy as dummy FROM
(
WITH dummy as
(SELECT d.dummy, d.dummy, d.dummy, d.dummy FROM dummy.dummy d
WHERE d.dummy = 'N'
UNION ALL
SELECT d.dummy, d.dummy, d.dummy, d.dummy FROM dummy.dummy d
WHERE d.dummy = 'N'
)
SELECT round(sum(abs(f.dummy)*r.dummy)/nullif(sum(abs(f.dummy)), 0), 4) AS dummy,
sum(abs(f.dummy)) AS dummy,
1 AS dummy,
cal.dummy AS dummy,
d2f.dummy AS dummy
FROM dual f
JOIN dual cal ON 1=1
AND cal.dummy = 'N'
JOIN dual s ON 1=1
AND s.dummy = f.dummy
AND cal.dummy >= s.dummy
AND cal.dummy < s.dummy
AND s.dummy in (5,6,7,9)
AND s.dummy = to_date('dummy','YYYYMMDD')
AND s.dummy = 'N'
JOIN dual r ON 1=1
AND r.dummy = f.dummy
AND cal.dummy >= r.dummy
AND cal.dummy < r.dummy
AND r.dummy = 7
AND r.dummy = to_date('dummy','YYYYMMDD')
AND r.dummy = 'N'
JOIN d2f ON 1=1
AND d2f.dummy = f.dummy
AND cal.dummy >= d2f.dummy
AND cal.dummy < d2f.dummy
WHERE 1=1
AND cal.dummy between to_date('dummy','YYYYMMDD')
and to_date('dummy','YYYYMMDD')
AND cal.dummy >= f.dummy
AND cal.dummy < f.dummy
AND f.dummy = to_date('dummy','YYYYMMDD')
AND r.dummy IS NOT NULL
AND f.dummy = 'N'
GROUP BY cal.dummy, d2f.dummy
UNION ALL
SELECT fr.dummy dummy,
df.dummy dummy,
1 dummy,
cal.dummy dummy,
df.dummy dummy
FROM dual df
JOIN dual fr ON df.dummy = fr.dummy
AND df.dummy IN (48,49)
AND fr.dummy = 13
AND fr.dummy <= df.dummy
AND fr.dummy >= df.dummy
AND fr.dummy = 'N'
AND fr.dummy <= df.dummy - df.dummy + 1
AND fr.dummy >= df.dummy - df.dummy + 1
JOIN dual cal ON cal.dummy between fr.dummy and fr.dummy-1
and cal.dummy = 'N'
WHERE df.dummy = date'5999-12-31'
AND cal.dummy between to_date('dummy', 'yyyymmdd')
and to_date('dummy', 'yyyymmdd')
and nvl(df.dummy,'N') <> 'Y'
UNION ALL
SELECT fr.dummy dummy,
df.dummy dummy,
1 dummy,
cal.dummy dummy,
df.uk dummy
FROM dual df
JOIN dual fr ON df.dummy = fr.dummy
AND df.dummy = fr.dummy
AND fr.dummy = 13
AND fr.dummy <= df.dummy
AND fr.dummy >= df.dummy
AND fr.dummy = 'N'
AND fr.dummy <= df.dummy - df.dummy + 1
AND fr.dummy >= df.dummy - df.dummy + 1
JOIN dual cal ON cal.dummy between fr.dummy and fr.dummy-1
AND cal.dummy between to_date('dummy', 'yyyymmdd')
and to_date('dummy', 'yyyymmdd')
AND cal.dummy = 'N'
WHERE 1=1
--and rownum < 20
AND df.dummy IN (48,49)
AND df.dummy = date'5999-12-31'
AND nvl(df.dummy,'N') <> 'Y'
)
a;