AiDOPWarehouse/server/Admin.NET.Web.Entry/UpdateScripts/1.0.380.verify.sql

SELECT
  (SELECT COUNT(*) FROM information_schema.STATISTICS
    WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'ado_s8_exception' AND INDEX_NAME = 'idx_s8_exception_assignee_status') AS assignee_idx,
  (SELECT COUNT(*) FROM information_schema.STATISTICS
    WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'ado_s8_exception' AND INDEX_NAME = 'idx_s8_exception_verifier_status') AS verifier_idx,
  (SELECT COUNT(*) FROM ado_s8_notification_layer WHERE notify_channel LIKE '%SignalR%') AS signalr_layers;