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....

Report message to a moderator

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: 67923
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

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Aug 02 20:25:43 CDT 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.