OCES-3 details-

Database

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

2 REPLIES

Re: OCES-3 details-

Hi All,

Any pointers for the above pls..?

Cheers!

Nishant

N/A

Re: OCES-3 details-

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