topic Re: Indexes For Views in Application Development and Automation Discussions

Indexes For Views

Former Member — Wed, 20 Jan 2010 15:17:56 GMT

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,

Re: Indexes For Views

Former Member — Wed, 20 Jan 2010 15:25:33 GMT

No. No tunnel to go through and work.

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

Re: Indexes For Views

Former Member — Wed, 20 Jan 2010 15:32:51 GMT

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

Re: Indexes For Views

Former Member — Wed, 20 Jan 2010 16:42:13 GMT

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.

Re: Indexes For Views

Former Member — Wed, 20 Jan 2010 16:46:29 GMT

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

Rob

Re: Indexes For Views

Former Member — Fri, 22 Jan 2010 06:05:42 GMT

Solved,

Thx,