Indexes For Views

[Former Member]

Hi gurus,

Is it possible to assign indexes to views ? If yes, how ? I can create indexes for views through database management software, but in SAP, in SE11 i found nothing for this.

Thx,

[Former Member]

No. No tunnel to go through and work.

Edited by: Kumar Manas Mishra on Jan 20, 2010 4:26 PM

[Former Member]

An index cannot be defined on a view. Because view is

virtual table, which consists of a subset of columns from

one more tables.

The Restrictions imposed on views are as follows:

<< Cut and paste without attribution from http://www.allinterview.com/showanswers/10530.html removed >>

Thanks

Rahul

Edited by: Rob Burbank on Jan 20, 2010 10:42 AM

[Former Member]

So if i can not create index on views, how can i get performance from big tables ? It is not reasonable to use view instead of table. I can use indexes and get more performance instead of view using same table.

[Former Member]

Using existing indexes effectively will give better performance than trying to use views.

Rob

[Former Member]

Solved,

Thx,