Question : Let’s say I have a table Foo with columns ID1, ID2 and a composite primary key defined over […]
Tag: statistics
Get NULL statistics for a column in MS SQL Server
Question : In MS SQL Server 2005, how can I extract statistical information about NULL fraction (or NULL count) for […]
How to ensure pg_stat_activity shows all my queries?
Question : I am working with pg_stat_activity in postgres. It is working and I can see queries in this view […]
Query execution plan is horrible until Statistics are Updated
Question : I hope you guys can help me here. Our application polls a message table every 3 seconds looking […]
PostgreSQL and query planner
Question : I have question about query planner in PostgreSQL. I know, that this planner is taking data from pg_statistics, […]
dbms_datapump API exclude statistics during import
Question : We are using dbms_datapump to copy data between different servers or to setup new schemas quickly. However importing […]
Update statistics for all databases all tables in a server
Question : Hi I have been working on a script to update statistics of all tables on all my DBs. […]
How can I reset the counters from pg_stat_database view?
Question : I know I can reset some counters by running: select pg_stat_reset() but some counters like xact_commit aren’t reset. […]
SQL Server recreating plans each day
Question : We have this problem in our production environment. Microsoft SQL Server 2008 R2 (SP1) – 10.50.2500.0 (X64) – […]
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 […]