The statistics tag has no wiki summary.
4
votes
2answers
84 views
Are SQL Server statistics stored in database or buffer pool?
Just wondering are statistics kept in the database but not in the memory? If I backup/restore the database from a prod server to a development server, would it keep the same statistics so that ...
3
votes
1answer
48 views
Does create / update statistics create transactions log?
Does creating or updating a SQL statistics, assuming on a large table, creates significant (or at all) transaction logs? I would think not as it does not change the underlying data or structure.
If ...
1
vote
2answers
43 views
sql server 2008 execution plan different on two production servers
We have two servers running SQL server 2008 R2, with identical databases, where we implemented a datawarehousing solution. The cube processing operation was taking a VERY long time in one of the ...
2
votes
1answer
83 views
Query requires 'Update statistics' very often in SQL Server
We have a few tables in our database. Since most of our queries are date based, we have constructed clustered index on 'date + primary key (surrogate)' combination and we enforce joins on date as well ...
0
votes
2answers
36 views
Find the average number of n:m connections of two tables?
I want to know to how many lists a user is assigned in average.
User
====
id
name
Lists_Users
===========
user_id
list_id
List
====
id
title
Is there a good way of receiving this number via ...
2
votes
0answers
70 views
Oracle: How to gather stats in a logical standby database?
I have a Primary and a (logical) Standby Database. The Schema 'APP' gets synced.
Now a User has performance issues running a query against some tables in this 'APP' schema of the Standby Database. On ...
7
votes
1answer
105 views
How does sampling work when updating statistics?
I have several massive tables. I'd like to ensure their statistics are up to date via a weekly maintenance plan.
However, doing so is taking too much time.
If I specify
WITH SAMPLE 50 PERCENT
...
0
votes
1answer
91 views
Postgres 9.1 statistics in pg_stat_database
I've been searching for some information about Postgres 9.1 stats which are stored in pg_stat_database - on the web and on IRC. I found SOME information for 9.2 but even that doesn't seem to be ...
3
votes
1answer
76 views
Can't understand results of pg_stat_statements view
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 = ...
7
votes
1answer
173 views
SQL Server Index vs Statistic
What are the differences between CREATE INDEX and CREATE STATISTICS and when should I use each?
0
votes
1answer
154 views
Oracle not trusting statistics after an import?
We are seing some strange behavior in the way Oracle is handling statistics of an imported schema.
We build a schema on the dev system, analyze if and import into the production with the stats.
For ...
2
votes
2answers
187 views
Problem with sp_Updatestats
I am having a problem when running sp_updatestats on my database it generates an error when my emp table is updating and disconnects I will paste the error here
Updating [dbo].[emp]
Msg 0, Level 11, ...
1
vote
1answer
265 views
Why is DBA_SEGMENTS presenting twice the amount of data than the DBA_TABLES?
I tried to compute the audit log table usage using the following steps:
Truncate all the audit log table data (i.e. AUD$)
Perform test case that inserts and update data, also delete statement but it ...
6
votes
1answer
170 views
AUTO_UPDATE_STATISTICS_ASYNC ON?
I have been advised that setting the AUTO_UPDATE_STATISTICS_ASYNC ON may be a good idea. I have been reading a couple of ideas and still not sure as this is a non default setting.
Any further ...
0
votes
1answer
79 views
Getting statistics of a table in Oracle
What is more efficient to gather table statistics:
Using dbms_stats.gather_table_stats?
Using analyze table?
