When i execute a select statement with a group by. I get a worktable created. When i run sysmon on the system during this period I only see APL Clustered Table activity in the Transaction Profile section. This seams to indicate ASE is creating the temp table, then adding a CI and then inserting. Is this correct? (The documentation I have seen tends to indicate that it should always use an APL heap table for worktables.) If so, is there a way to force ASE to insert into a heap instead? To save of index maintenance and page splits. I'm using 12.5.


APL Heap Table 0.0 0.0 0 0.0 %

APL Clustered Table 529.5 10590.0 10590 100.0 %

Data Only Lock Table 0.0 0.0 0 0.0 %