Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Snapshot and Indexes
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 ZappaReceived on Sun Mar 05 2000 - 00:00:00 CST