Home » Developer & Programmer » Reports & Discoverer » can i create index on view
can i create index on view [message #89846] Thu, 05 August 2004 03:16 Go to next message
sandhya
Messages: 15
Registered: February 2002
Junior Member
Can i create index on a view column.

Report message to a moderator

Re: can i create index on view [message #89848 is a reply to message #89846] Thu, 05 August 2004 06:15 Go to previous messageGo to next message
Himanshu
Messages: 457
Registered: December 2001
Senior Member
No, you cannot.
Views do not store any data and are Procedural i.e. based on the query on which they were formed, they fetch data.

Regards
Himanshu

Report message to a moderator

Re: can i create index on view [message #89852 is a reply to message #89846] Thu, 05 August 2004 22:50 Go to previous message
cdv ramesh
Messages: 1
Registered: August 2004
Junior Member
No you cannot create index on view.
View does not have any structure of its own.
A view is created on single or mutiple tables.
The tables created can will have indexes and not on the columns selected for the view.

Report message to a moderator

Previous Topic: reports & forms
Next Topic: How to create a List box in Parameter form
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 10:22:09 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.