Oracle EE slower than Oracle XE
Dear community,
I would like some advice on which parameter to check on my enterprise db to understand why it is slower than XE db.
I have a query:
SELECT DT.TREE_ID PARENT_ID,
DT.NAME PARENT_NAME,
DT.UNIVERSE AS UNIVERSE,
DT.TYPE AS TYPE,
CONNECT_BY_ROOT dt.TREE_ID,
CONNECT_BY_ROOT dt.name,
LEVEL - 1 DISTANCE
FROM TREES DT
START WITH DT.TYPE = 'FIELD'
CONNECT BY NOCYCLE DT.TREE_ID = PRIOR DT.PARENT_ID
As I have 2 possible values in TYPE (FILED or NODE), I wanted to test a bitmap index (which is not possible on XE). So I created everything on a dev EE db to see if a bitmap index would be good.
I would like some advice on which parameter to check on my enterprise db to understand why it is slower than XE db.
I have a query:
SELECT DT.TREE_ID PARENT_ID,
DT.NAME PARENT_NAME,
DT.UNIVERSE AS UNIVERSE,
DT.TYPE AS TYPE,
CONNECT_BY_ROOT dt.TREE_ID,
CONNECT_BY_ROOT dt.name,
LEVEL - 1 DISTANCE
FROM TREES DT
START WITH DT.TYPE = 'FIELD'
CONNECT BY NOCYCLE DT.TREE_ID = PRIOR DT.PARENT_ID
As I have 2 possible values in TYPE (FILED or NODE), I wanted to test a bitmap index (which is not possible on XE). So I created everything on a dev EE db to see if a bitmap index would be good.
0