2007 Jun 04 6:49 PM
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
2007 Jun 04 7:07 PM
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
2007 Jun 04 7:07 PM
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
2007 Jun 04 10:03 PM
I think you are probably making too much work for yourself. Can you not go directly to BKPF using AWTYP and AWKEY?
Rob
2007 Jun 04 10:25 PM
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.
2007 Jun 05 5:15 AM
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
2007 Jun 05 10:23 AM
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........