Home » RDBMS Server » Server Administration » Creating Views and Indexing Views
Creating Views and Indexing Views [message #54432] Mon, 18 November 2002 04:17 Go to next message
Paul Gibson
Messages: 2
Registered: November 2002
Junior Member
Hi,

I am trying to create a view of a large table (1,000,000 rows) which has keys. However, when I run 'help viewname' the output indicates that the resulting view does not contain index/key information. As I intend to use the view rather than the base table to execute queries, I was wondering if the lack of key info will have a detremental effect on the query exectuion time.

Thanks,

Paul

Report message to a moderator

Re: Creating Views and Indexing Views [message #54433 is a reply to message #54432] Mon, 18 November 2002 06:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
1. A view is just a stored or predefined query.
2. Everytime u query a view, the defining query is executed.
3. A view can be used JUST LIKE  TABLE.
4. But, the view does not require any storage( becuase, it just queries the base table).
5. So, you NO NEED TO INDEX THE VIEW.
   you can index only the base table.

Report message to a moderator

Re: Creating Views and Indexing Views [message #54482 is a reply to message #54432] Tue, 19 November 2002 13:30 Go to previous message
Kossaku Nakombi
Messages: 12
Registered: November 2002
Junior Member
Unless you are using Materialized Views...

Report message to a moderator

Previous Topic: ora 06502
Next Topic: Massive Rollback Segment
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Dec 27 16:40:33 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.