SELECT DISTINCT TABLE_SCHEMA AS db_name FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA LIKE 'agency_1150%' AND TABLE_NAME = 'pDeposit' ORDER BY TABLE_SCHEMA

Adding Performance Indexes for remittance_manager.cfm

Processing #getAgencies.recordcount# agency databases...

Processing: #db_name#

SELECT COUNT(*) AS idx_exists FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = AND TABLE_NAME = AND INDEX_NAME =

&##9888; #idxDef.index# already exists - skipping

SELECT COUNT(*) AS tbl_exists FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = AND TABLE_NAME =

&##9888; Table #idxDef.table# not found in #db_name# - skipping #idxDef.index#

CREATE INDEX #idxDef.index# ON #db_name#.#idxDef.table# (#idxDef.columns#)

&##10003; Created #idxDef.index# on #idxDef.table#

&##9888; #idxDef.index# already exists (duplicate) - skipping

&##10007; Error creating #idxDef.index#: #cfcatch.message#

&##10007; Error processing #db_name#: #cfcatch.message#

Summary

Databases processed: #successCount#

Indexes created: #createdCount#

Indexes skipped: #skippedCount#

Errors: #errorCount#

Total databases: #getAgencies.recordcount#

Remittance index migration complete.