write optimized, direct , standard dso

[Former Member]

hi,

     plz tell me in which scenario we will use write optimized dso, direct dso, standard dso??? and the exact difference between all of the 

note:don't tell that standard have 3 tables,direct and write op are having 1 table

[Former Member]

Hi Venkat

The major difference between three types of DSO are..

Type                                   Structure                         Data Supply                              SID Generation

Standard DSO               Consists of three tables:       From data transfer process          Yes

                                     activation queue,

                                      table of active data,

                                      change log

Write-Optimized DSO      Consists of the table of           From data transfer process       No

                                      active data only

DSO for Direct Update    Consists of the table of               From APIs                            No

                                   active data only