Tables
(0)
Name | Rows | CreatedBy | CreatedDate | DateLastModified | DatabaseName | Durability | FullName | Identifier | IsLargeTable | IsMemoryOptimized | IsView | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
August
2026
:
| August
2026
:
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| No records to display. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
.
Name | Type | # | Len | Null | PK |
|---|---|---|---|---|---|
| No records to display. | |||||
All Columns
Table | Column | # | Type | Len | Precision | Scale | NULL? | PK | FK | ID | IK | UQ | Computed | INDEXES | MISSING INDEXES | Indexes | MissingIndexes | Constraints | ForeignKeys | ReferencedByForeignKeys | ColumnDefault | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
| ||||||||||||||||
| No records to display. | ||||||||||||||||||||||
Maximum Reach
0 TABLE
0%
Highest Confidence Fit
PlanDrivenExecution [Compact] (0 Joins)
Duplicates
Visualization
AS400
- AS400
- Light
Engine Layout Configuration
KamadaKawai
- CircularStar
- FruchtermanReingold
- FruchtermanReingoldBounded
- ISOM
- LinLog
- KamadaKawai
- Random
- Sugiyama
- TreeBallon
- TreeDouble
- TreeSimple
- None
Select a configuration preset...
- JEO
- BalancedDefault
- StrongCouplingClustered
- LooseSprawlingExploration
- HighDensityCompact
Tuning Constants
(10 - 200)
(0.1 - 25)
(1 - 5)
(0.1 - 5)
Query Editor
AS400
Auto-Generate
- AS400
- Light
GENERATION OPTIONS
Root Select
AllColumns
Join Select
- AllColumns
- Star
- PkOnly
- None
None
- AllColumns
- Star
- PkOnly
- None
Levels Up
Levels Down
Stored Procedures ( )
Schema | Procedure Name |
|---|---|
| No records to display. | |
Views ( )
Schema | View Name |
|---|---|
| No records to display. | |
Relations: .
Primary Table | Primary Column | Foreign Table | Foreign Column | FK Null | Composite Key |
|---|---|---|---|---|---|
| No records to display. | |||||
Current Query Joins ( 0 )
Include | Source Table | Source Column(s) | Target Table | Target Column(s) | FK Constraint Name |
|---|---|---|---|---|---|
| No records to display. | |||||
TREEMAP
71 NODES · Σ 785,569
HOVER A NODE // CLICK TO SELECT
8 columns showing
- PrimaryKeyColumn
- Name
- FragmentationPercent
- UnindexedFkCount
- UnindexedFkSeverity
- CoveragePercent
- CoverageSeverity
- MissingIndexCount
- MissingIndexSeverity
Name | FragmentationPercent | UnindexedFkCount | UnindexedFkSeverity | CoveragePercent | CoverageSeverity | MissingIndexCount | MissingIndexSeverity |
|---|
Live Blocking Monitor: No Last Update Time
Current Root Blockers (Active Threads)
| EC | SPID | Victims Count | Login | Host Machine | Application | Tran Age (s) | SQL Query Command |
|---|---|---|---|---|---|---|---|
| No records to display. | |||||||
Chronological Blocking Snapshot Log (Last 2 Hours)
Collection Timestamp | Total Contending Sessions | Calculated Root Causes |
|---|---|---|
| No records to display. | ||
Top Duration Queries
| EC | AvgCpuMs | AvgDurationMs | AvgLogicalReads | Executions | MaxDurationMs | QueryId | Preview |
|---|---|---|---|---|---|---|---|
| No records to display. | |||||||
Wait Categories
| EC | Executions | MaxWaitMs | TotalWaitMs | WaitCategoryDesc | WeightedAvgWaitMs | QueryId | QueryPreview |
|---|---|---|---|---|---|---|---|
| No records to display. | |||||||
Wait Categories Simple
| EC | MaxWaitMs | TotalWaitMs | WaitCategoryDesc | QueryId | QueryPreview |
|---|---|---|---|---|---|
| No records to display. | |||||
Wait Profiles
PctOfTotal | ResourceWaitSec | SignalWaitSec | WaitBucket | WaitingTasksCount | WaitSec | WaitType |
|---|---|---|---|---|---|---|
| No records to display. | ||||||
23 columns showing
- PrimaryKeyColumn
- Name
- Rows
- Columns
- ForeignKeys
- ReferencedByForeignKeys
- Relations
- Indexes
- MissingIndexes
- FragmentedIndexes
- AverageFragmentationPct
- ReachableTables
- ReachablePct
- MaxTraversalDepth
- AverageTraversalDepth
- DuplicateCount
- JoinCount
- NodesVisited
- ConfidenceScore
- Statistics
- ExtendedProperties
- CheckConstraints
- Triggers
- Synonyms
Name | Rows | Columns | ForeignKeys | ReferencedByForeignKeys | Relations | Indexes | MissingIndexes | FragmentedIndexes | AverageFragmentationPct | ReachableTables | ReachablePct | MaxTraversalDepth | AverageTraversalDepth | DuplicateCount | JoinCount | NodesVisited | ConfidenceScore | Statistics | ExtendedProperties | CheckConstraints | Triggers | Synonyms |
|---|
16 columns showing
- PrimaryKeyColumn
- Name
- Indexes
- MissingIndexes
- ForeignKeys
- ReferencedByForeignKeys
- KeyIndexCount
- IncludeIndexCount
- Clustered
- NonClustered
- CoveringIndexes
- NonCoveringIndexes
- UniqueConstraints
- CheckConstraints
- MinFrag
- MaxFrag
- AvgFrag
Name | Indexes | MissingIndexes | ForeignKeys | ReferencedByForeignKeys | KeyIndexCount | IncludeIndexCount | Clustered | NonClustered | CoveringIndexes | NonCoveringIndexes | UniqueConstraints | CheckConstraints | MinFrag | MaxFrag | AvgFrag |
|---|
8 columns showing
- PrimaryKeyColumn
- Name
- ObjectType
- Parameters
- ParameterNames
- OutputColumns
- OutputColumnNamess
- Definition
- FullName
Name | ObjectType | Parameters | ParameterNames | OutputColumns | OutputColumnNamess | Definition | FullName |
|---|
5 columns showing
- PrimaryKeyColumn
- Name
- Columns
- Relations
- ColumnNamess
- Definition
Name | Columns | Relations | ColumnNamess | Definition |
|---|
AdventureWorksFK
