HPCC-11253 Do not lock superfiles in roxie

Don't include spill files or write activities.

Handle opt flag on indexes properly.

Signed-off-by: Richard Chapman <rchapman@hpccsystems.com>
Merge pull request #5790 from richardkchapman/roxie-file-fixes

HPCC-11253 Do not lock superfiles in roxie

Reviewed-by: Gavin Halliday <ghalliday@hpccsystems.com>