Question : This question already has answers here: Filling in missing dates in record set from generate_series() (2 answers) Closed […]
Tag: statistics
Can’t understand results of pg_stat_statements view
Question : I configured my postgresql.conf (my version is 9.1) with the normal persistent configuration: shared_preload_libraries = ‘pg_stat_statements,plperl’ custom_variable_classes = […]
Stats for usage of columns in queries
Question : I am using MS SQL Server 2014. Have some kind of DWH. Is there some way to find […]
Check which statistics were used in query optimization
Question : Is it possible to tell when statistics were last accessed by a query using T-SQL? I’m trying to […]
Is there a faster way to count JSONB tags?
Question : I’m trying to squeeze some more performance out of this query in Postgres 9.5. I’m running it over […]
How to calculate cache misses for PostgreSQL
Question : I’m administering a server where a tool using a PostgreSQL runs. The tool takes care of most PostgreSQL […]
SQL User with only access to maintain indexes and statistics
Question : I need to have an AD user account with access to all databases on a specific instance of […]
Why is statistics update slower on a clustered columnstore than on a rowstore?
Question : I’ve moved several large tables (each with >10^9 rows and a couple of dozens columns) from clustered rowstore […]
Update Statistics with full scan for a single table
Question : My application search becomes slow some times in a day.And whenever i update statistics for a particular table,it […]
Improve the poor performance of the sys.dm_db_stats_properties DMV
Question : We have some databases with wide tables on COLUMNSTORE compression (21 or 30 COLUMNS) and 2500 partitions (by […]