Manuel Duran Aguete wrote:

> > >     * It's there a tool or command like VACUUM in Postgresql or isn't
> > > neccessary?
>       Vaccuum is used to  free the space used by deleted 
> rows, updated ones ,
> etc and for recreate the optimizer statistics.

SAP DB can be used without so-called reorganization, that means without
using a special tool to free space after delete / update.
Therefore there is no tool necessary to do so.

Update statistics has to be done by the user.
As far as I know, there is no tool available to do this.


>       In a area of my project I need to pass data between two 
> process very
> quickly, about 30 records/sec. One processes put the data and anothers
> take it, process and next delete it. Due a design requirement 
> I need to
> do that throught a DB. Must I configure this db as LiveCache ?

Nooo,
OLTP is the only instance type you should use.

Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to