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';