Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
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: 6
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: 17653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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) ] [ ]

Current Time: Thu Jul 24 21:49:43 CDT 2008

Total time taken to generate the page: 0.00872 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.