Hi all, a standard DBXTRACT reload.sql file contains a bunch of LOAD STATISTICS statements, typically based on a particular page size. AFAIK, they are used to refine the table sta …

Using v11.0.1 Does anyone have any real world experience of immediately refreshed materialized views versus manually refreshed materialized views? We have a situation where we th …

I just tried a simple exclusion query of the form select * from T1 where C1 not in (select C2 from T2) where C1 is a varchar column. That works very fast if C1 and C2 are bo …