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