You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@trafodion.apache.org by Roberta Marton <ro...@esgyn.com> on 2016/02/04 23:01:47 UTC

Generating statistics for volatile tables

Should Trafodion be able to generate and use statistics for volatile
tables?



When I try to do an update statistics on a volatile table it fails as
follows:



create volatile table t1 (c1 int not null primary key, c2 int);

insert into t1 values (1,1), (2,2), (3,3), (4,4);



update statistics for table t1 on every column;



*** ERROR[4082] Object TRAFODION.SEABASE.T1 does not exist or is
inaccessible.



   Regards,

   Roberta