0 - 11 of 11 tags for collect stats

Hi,
Can anyone help me on this question??... For GTT Tables while defining stats which one of the below Query works better?
 1.

collect stats on tablename column ColumnNM/Index

OR
2.

Hi
     When i try to execute the below statement inside a Stored Procedure as below i get an error as stated:
CALL DBC.SYSEXECSQL ('COLLECT STATISTICS ON DBNAME.Table_Name  INDEX (Column1);');  
ERROR:
The user does not have STATISTICS access to DBNAME.Table_Name.
 

Hi,
What could be the reason for a collect stats statement failure on a single column because of spool space (In a enough spool env. )?
Also on execution on Collect stats statement what Teradata DB does internally on Vprocs & Vdisks ?
Thanks in Advance .

Nagendra

As volatile table definition does not go into DD, how Indexes and stats works on volatile table?

I have a long query generated from Microstrategy with lots of joins which was running our of spool space. I checked the query and confirmed that we had stats collected on all the join columns and stats were current. Then there was one column on which I dropped stats, it had both single and multi column stats after which the query started to run fine.

Hi All,
    Does collecting stats on unused columns in anyway influence the execution plan.
Ex

Hello,
 
I need to check whether stats defined on the tables are really used by the optimizer or just ignored. Since collect stats are more CPU consuming , need inputs on this to check all the stats defined on the tables and to remove those are not useful.
 
Regards

Hi,

I am having two questions related to collect stats.

I have a table with primary and secondary indexes defined on it. Something like:

CREATE TABLE DB1.TBL1
(COL1 INTEGER,
COL2 CHAR(10),
COL3.....
COL10)
UNIQUE PRIMARY INDEX PMY_idx ( COL1 )
INDEX SEC_idx ( COL2 );

In which dbc tables in teradata is the demographic information
of collecting statistics on tables stored?

From Books:

When doing collect stats on fields/indexes , system collects the information like: total row counts of the table, how many distinct values are there in the column, how many rows per value, is the column indexed, if so unique or non unique etc

The above information are known as statistics.
___________________________________________________________________________
Example:
Table "Emp_Details" has the primary index "Emp_Name". I use this index "Emp_Name" in my joining condition/Where clause.

case1: I dont have collect stats on "Emp_Details" table.