In my previous shop we did index our snapshots. You
will take a performance hit on them if done but if
there is a business need then I suggest doing it. You
should not need to create an unique index on them
though since the rowid is already indexed. The data
should be already unique based on the master table. I
would just create the index but not unique. If you
ever have to rebuild the snapshot you will need to
drop the indexes first.
- "LoughMiller, Gregory"
<Gregory_LoughMiller_at_bscc.bls.com> wrote:
> we did.. It slows the snapshots... and if you have
> to rebuild-it adds
> complexity/time to rebuilding the snapshot log..
>
> read only snapshots-correct?
>
> -----Original Message-----
> Sent: Tuesday, August 29, 2000 9:45 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Oracle says "Do not use CREATE UNIQUE INDEX on
> snapshots". Can somebody
> tell me why ? I couldn't find any explanation for
> this. But I need to
> create unique indexes, for performance reasons. Is
> there any workarounds
> for this. I'm using Oracle 7.3.4 on Solaris 2.8.
>
> Thank you !
>
>
> --------
> @biy @lemu
> abiy.alemu_at_criltelecom.com
> <mailto:abiy.alemu_at_criltelecom.com>
> Cril Telecom Software
> France
>
> --
> Author: ALEMU Abiy
> INET: abiy.alemu_at_criltechnology.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
> --
> Author: LoughMiller, Gregory
> INET: Gregory_LoughMiller_at_bscc.bls.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
Do You Yahoo!?
Received on Tue Aug 29 2000 - 09:43:58 CDT
