Re: Snapshot using rowid vs Primary Key

"> > What is the difference between
> > create snapshot <> refresh fast with ROWID ..
> > vs
> > create snapshot <> refresh fast with Primary Key ..
> >
> > I am able to understand Primary Key being used to compare rows but how
 is
> > the rowid used ?
> >
>
>
> For the refresh a snapshot log is created, this simply is a table in which
> all changes to the master-table are stored. On a snapshot-refresh the
> snapshot-site looks into the log and updates only this data, which are
 keyed
> either by primary key, by rowid or both. The rowid is the physical address
> of a row in the table. But snapshots created with rowid have some
> limitations e.g. no aggregation funcitons (SUM, AVG, MIN) or DISTINCT or
> table-joins, which the primary key-snapshots don't have. The rowid is used
> for backward-compatibility to 7.xx servers, for 8.xx its better to use
> primary key snaphots.
>
> Mike
>
> Do I have any option if some of the tables do not have a Primary Key (and
I am not allowed to create a n artificial Primary Key ?

Sandeep
>
Received on Tue Sep 12 2000 - 01:47:06 CDT