Re: Is it posible to create indexes on a snapshot ?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 19 Oct 1999 19:50:14 +0800
Message-ID: <380C5AF6.5F57@yahoo.com>

Guy Dallaire wrote:
>
> I was reading a post mentionning that one cannot create a UNIQUE index
> on a snapshot. But I was wondering if it is possible to create other
> types of indexes on a snapshot.
>
> If it is possible, on which object does the index need to be created.
> Isn't a snapshot a VIEW ? I don't think we can create an index on a
> view, can we ? ? ?
>
> Also, the view is based on some SNAP$... object. Should the indexes be
> created on this object then ?
>
> Finally, how does oracle maintain a snapshot, will I lose my index
> when the snapshot gets refreshed ? I mean, does it only truncate the
> table or does it drop + recreate it ?
>
> Thanks
> -----------------------------
> Guy Dallaire, Sysadmin/DBA
> Centre de recherche industrielle du Quebec
> Ste-Foy, QC, Canada
> http://www.criq.qc.ca
> e-mail: gdallair_at_criq.qc.ca
> ICQ: 18846092
Indexes can be created on the SNAP$_xxx tables.

Your view can then take advantage of them

A refresh will not drop the table and your indexes will be preserved. (But if you do a full refresh, you are probably better off dropping them and then adding them again after the refresh)

Cheers
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Oct 19 1999 - 06:50:14 CDT