lyft_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

lyft_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 lyft_update_row_count_object_statistics @databaseName = 'AdventureWorksDW2012_mssql', @schema_name = 'dbo', @tableName = 'DimDate';

See Also