Example 1 (When DatabaseName is Not Specified)
CALL TDSTATS.AUTODBAOBJECTS('{}');
Result:
| DatabaseName | TotalTables | NumTablesNotAutoDba | NumTablesFullAutoDba | NumTablesSemiAutoDba | LowestAutoDBAStartTime |
|---|---|---|---|---|---|
| InventoryDb | 2 | 0 | 0 | 2 | 2023-07-01 16:11:57 |
| SalesDb | 3 | 1 | 1 | 1 | 2023-07-08 16:31:59 |
| CustomerDb | 3 | 1 | 0 | 2 | 2023-07-08 16:32:00 |
Example 2 (When DatabaseName is Specified as an Input Key Value)
CALL TDSTATS.AUTODBAOBJECTS('{"DatabaseName":"SalesDb"}');
Result:
| DatabaseName | TableName | AutoDBA | AutoDBAStartTime |
|---|---|---|---|
| SalesDB | t1 | F | 2023-07-01 16:11:57 |
| SalesDB | t2 | S | 2023-07-08 16:21:10 |
| SalesDB | t3 | N |