All Forums Database
29 Jun 2013
OCES-3 details-

Hi Experts,
I am bit unclear about the OCES-3 (Optimizer Cost Estimation Subsystem version 3) in the stats area  and BMSMS (bit map set manipulation set) in the Query execution.
Can any one please suggest some pointers for the above topics to deep dive in it..
 
Cheers!
Nishant
 
 

11 Jul 2013

Hi All,
Any pointers for the above pls..?
Cheers!
Nishant

dnoeth 4628 posts Joined 11/04
11 Jul 2013

Hi Nishant,
BMSMS: search for "nusi bit mapping" in the "Database Design" manual 
OCES: there was an Orange Book a few years ago on this topic, in the "SQL REquest and Transaction Processing" manual are a few hundred pages on cost estimation and optimization :-)
 
Dieter 

Dieter

You must sign in to leave a comment.