Parallel Execution on small table
Hi
we had a table with 3 records. The create script shows parallel = 4 is implemented.
Why try the optimizer to parallize this query?
Should we set to noparallel?
the table has also 3 indexes, from my point of view made this no sense, can somewhere agree with me?
The statistics are currently, the tables does'nt growth during the day (static values).
BR
Daniel
TRACE
***********
PARSING IN CURSOR #640560520 len=174 dep=1 uid=58 oct=3 lid=58 tim=2484800604630 hv=772808885 ad='c3e4b8750' sqlid='2uq7yrsr1085p'
SELECT warehouseSiteId, longName, shortName, flagActive, agentIdentifier, reserved, genDat, genInfo, modDat, modInfo, modVersion FROM WarehouseSite WHERE agentIdentifier =:1
END OF STMT
we had a table with 3 records. The create script shows parallel = 4 is implemented.
Why try the optimizer to parallize this query?
Should we set to noparallel?
the table has also 3 indexes, from my point of view made this no sense, can somewhere agree with me?
The statistics are currently, the tables does'nt growth during the day (static values).
BR
Daniel
TRACE
***********
PARSING IN CURSOR #640560520 len=174 dep=1 uid=58 oct=3 lid=58 tim=2484800604630 hv=772808885 ad='c3e4b8750' sqlid='2uq7yrsr1085p'
SELECT warehouseSiteId, longName, shortName, flagActive, agentIdentifier, reserved, genDat, genInfo, modDat, modInfo, modVersion FROM WarehouseSite WHERE agentIdentifier =:1
END OF STMT
0