Subject | System Catalog Additions for ODS 12 |
---|---|
Author | plinehan |
Post date | 2009-11-11T21:23:53Z |
Hi all,
Not sure if this is a topic for Architect or General,
so I'll try here first - if unsuitable, please advise.
In Paul Beach's blog here
http://paulbeachsblog.blogspot.com/2009/10/system-catalog-additions-in-ods-12.html
he mentions additions to the system tables, notably
RDB$RELATIONS
+ RDB$STATISTICS (blob with binary statistics for the optimizer)
My question is why do these statistics have to be
in blob form - why can they not be held as data
in tables in the way much (most/all?) of this class
of data is held in (dare I mention it <gasp>) Oracle?
Any views (pun intended!), ideas or opinions welcome.
Rgs.
Paul...
Not sure if this is a topic for Architect or General,
so I'll try here first - if unsuitable, please advise.
In Paul Beach's blog here
http://paulbeachsblog.blogspot.com/2009/10/system-catalog-additions-in-ods-12.html
he mentions additions to the system tables, notably
RDB$RELATIONS
+ RDB$STATISTICS (blob with binary statistics for the optimizer)
My question is why do these statistics have to be
in blob form - why can they not be held as data
in tables in the way much (most/all?) of this class
of data is held in (dare I mention it <gasp>) Oracle?
Any views (pun intended!), ideas or opinions welcome.
Rgs.
Paul...