OraFAQ Forum: Server Administration » Is it possible to Create Index for VIEWS too?

Home » RDBMS Server » Server Administration » Is it possible to Create Index for VIEWS too?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Is it possible to Create Index for VIEWS too? [message #60943]

Tue, 16 March 2004 00:52

JoinNepal
Messages: 33
Registered: October 2003

Member

Hello,
Is it Possible to Create Index for View too?
If No, is there any Idea to make fast execution of the data from the Views?

Hope to Hear from you soon..
Thank you..
Yours,
Roshan

Report message to a moderator

Re: Is it possible to Create Index for VIEWS too? [message #60946 is a reply to message #60943]

Tue, 16 March 2004 01:38

Anatol Ciolac
Messages: 113
Registered: December 2003

Senior Member

make index on tables, from whom select data.

Report message to a moderator

Re: Is it possible to Create Index for VIEWS too? [message #60983 is a reply to message #60943]

Thu, 18 March 2004 00:11

IA
Messages: 91
Registered: March 2004

Member

Hi,

Try using Materialized views. Should make things quicker, but will use more disk space.

Thanks ... IA

Report message to a moderator

Re: Is it possible to Create Index for VIEWS too? [message #61011 is a reply to message #60983]

Fri, 19 March 2004 06:00

Sanjay
Messages: 236
Registered: July 2000

Senior Member

make sure you refresh the materialized view...

Report message to a moderator

Previous Topic:	moving ORACLE_HOME
Next Topic:	How to plan a Database Size.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 11 20:28:02 CDT 2025