Overview
The SQL Capture Table Scan Analyzer is an add-on component to SQL Capture, enabling you to analyze captured SQL statements to identify any table or index scans incurred by those SQL.
Major benefits include:
- Check a selected group of SQL statements for any table scans with just a few mouse clicks
- Identifies full-table heap scans and (on SQL Server) full clustered index scans
- Sorting and drill-downs assist in spotting table scans on your largest tables
The SQL Capture Table Scan Analyzer is available for SAP Sybase ASE and Microsoft SQL Server.
Features
The SQL Capture Table Scan Analyzer performs “static” analysis of SQL statements captured by SQL Capture. It features a wizard-based interface that guides you through selecting SQL statements to analyze, and then it examines the query plans for those SQL to identify where table scans would occur.
After the analysis is complete, the Table Scan Analyzer will display table scans by table, so you find the tables that were scanned the most, identify table scans on the largest tables, etc.
You can click on a table to see the SQL statements that scanned that table along with the full query plan for each table.
Database Support
The SQL Capture Table Scan Analyzer works with SAP Sybase ASE versions 11.0 through 16.0 and Microsoft SQL Server versions 6.5 through 2022.