Robert,

> > What indexes are defined on the BranchSend table?
>
> CREATE INDEX BranchSend_RegionRef ON BranchSend(RegionRef)^
> CREATE INDEX BranchSend_SendTable ON BranchSend(SendTable)^
> CREATE INDEX BranchSend_PkRef ON BranchSend(PkRef)^
> CREATE INDEX BranchSend_TransConf ON BranchSend(TransferConfirmed)^
> CREATE INDEX BranchSend_TransferBatchRef ON

BranchSend(TransferBatchRef)^

How many unique RegionRef values are there?

How many unique SendTable values are there?

What is the exact SQL and PLAN generated for the counts query?


Sean