Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Snapshot and Indexes

Re: Snapshot and Indexes

From: Paul de Anguera <nospam_at_quidnunc.net>
Date: 2000/03/05
Message-ID: <89stuf$o4m$1@news.chatlink.com>#1/1

In article <89rmgh$kv3$1_at_nnrp1.deja.com>, ydias_at_hotmail.com wrote:
.. In the target database, the
>snaphots are used for complex queries. Oracle creates tables named
>SNAP$Snaphot_name for each snapshot. Can I create indexes on these
>tables....

Yes; I did. But keep in mind that they will increase the overhead of refreshing the snapshot.

Paul de Anguera | "You can't write a chord ugly enough to say
Reply to:       | what you want to say sometimes, so you have to
deanguer@       | rely on a giraffe filled with whipped cream."
quidnunc.net    | - Frank Zappa
Received on Sun Mar 05 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US