Hi

> What indexes are defined on the BranchSend table?
>
>
> Sean
>
>

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)^


They are to improve a number of other searches as well.

> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>
>