qua_update_row_count_object_statistics#
Updates rowcount statistics for given table.
If possible, it uses native statistics mechanism of underlying database provider. In other case uses regular SQL queries to gather needed information.
Does not support approximate row count.
Syntax#
qua_update_row_count_object_statistics 'databaseName' [, 'schema_name' ] [, 'tableName' ] [;]
Arguments#
‘databaseName’
Name of the database in which table is present.
‘schemaName’
Name of database’s schema in which table is present.
‘tableName’
Name of the table which statistics are to be updated.
Example#
Updates row count statistics for AdventureWorksDW2012_mssql.dbo.DimDate.
EXEC qua_update_row_count_object_statistics @databaseName = 'AdventureWorksDW2012_mssql', @schema_name = 'dbo', @tableName = 'DimDate';