SQL performance improvements in ACP methods