Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Index vs views in performance

Former Member
0 Kudos
267

HI,

Can creating a view will help to improve performance.I have to read from table RBKP but i don't have index fields , can i create view to get faster access.will it help over secondary index.

Regards,

Karthik.k

1 ACCEPTED SOLUTION

former_member181962
Active Contributor
0 Kudos
139

Hi Karthik,

Creating a View is not an alternative for creating an Index.

We create Views in when we need data from two or more tables based on a common condition.

In order to inprove performance you have to create an index on the table RBKP(do not create many indexes as it would infact slow down the retrieval instead of retrieving).

Regards,

Ravi

5 REPLIES 5

former_member181962
Active Contributor
0 Kudos
140

Hi Karthik,

Creating a View is not an alternative for creating an Index.

We create Views in when we need data from two or more tables based on a common condition.

In order to inprove performance you have to create an index on the table RBKP(do not create many indexes as it would infact slow down the retrieval instead of retrieving).

Regards,

Ravi

Former Member
0 Kudos
139

I think you are probably making too much work for yourself. Can you not go directly to BKPF using AWTYP and AWKEY?

Rob

Former Member
0 Kudos
139

Creating secondary index will give better performance and i think no need to have view ..

One thing - check the table RBKP and how many programs are depend on this table,if there are so many programs then do not create secondary index,still if you create index then other programs operation will go down,anyhow check with basis guy to go further.

Former Member
0 Kudos
139

hi,

if u are comparing views vs secondary indexes, then secondary indexes are better , view will improve performance little bit and will be constant but if u r usingh secondary indexes then overall performance will be better.

Disadvantage of secondary indexes is that it will occupy space, it will slow down add , delete operation slow.

Jogdand M B

Former Member
0 Kudos
139

We can create Views only we need data from two or more tables based on a common condition.

Index is totally different from Views

If you want to improve performance you have to create an index on the database table........