Home » Server Options » Replication » Index on a snapshot in 8i (Oracle 8i)
Index on a snapshot in 8i [message #297721] Sat, 02 February 2008 23:35 Go to next message
vishubms
Messages: 10
Registered: October 2006
Location: Bangalore
Junior Member
Dear Techies,

Can i create an index on a snapshot... to increase the performance of searching.... in Oracle 8i....

Please provide with syntax...

Or else tell me how to increase the speed of a query on Snapshot...


Regards,

Vishwanath....
Re: Index on a snapshot in 8i [message #297724 is a reply to message #297721] Sun, 03 February 2008 00:21 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can create an index on the underlying table.
You'll the name of this table in all_snaphots.table_name.

Regards
Michel
Previous Topic: Materialized view: Query rewrite with dimension rollup doesn't work
Next Topic: materialized View Error : existing state of packages has been discarded
Goto Forum:
  


Current Time: Thu Mar 28 06:30:11 CDT 2024