topic Re: View on a single table in Application Development and Automation Discussions

View on a single table

Former Member — Thu, 18 Sep 2008 10:36:30 GMT

Hi all,

my question is: does have any sense to use a view for a single table selection ?

I need to make a selection on a db table and I haven't any value neither for the primary key nor for any secondary index.

Can I improve the table access speed in any other way ???

Re: View on a single table

Former Member — Thu, 18 Sep 2008 10:43:12 GMT

For that purpose SAP created some of the Views and if table consists of many key fields and fields then it will be useful. Create the view with required fields and check the performance.

Re: View on a single table

Former Member — Thu, 18 Sep 2008 10:43:24 GMT

Hello

1. Yes. View for a single table may be.

2. If you haven't any value neither for the primary key nor for any secondary index, create new index with fiedls for your values.

Re: View on a single table

Former Member — Thu, 18 Sep 2008 11:35:50 GMT

Thank's

I've created a view and analyzed performance with ST05 but that transaction seems to be not too much useful...

Re: View on a single table

Former Member — Thu, 18 Sep 2008 11:36:52 GMT

Thanks,

what are the side effects or things to considerate when creating index oa a db table?

Edited by: Vincenzo de Stefano on Sep 18, 2008 1:37 PM

Re: View on a single table

Former Member — Thu, 18 Sep 2008 11:39:12 GMT

for creating an index, first you should see what all relevant fields need to be used which can be used in index creation.

So, when a select statement executes this index gets triggered for faster retrieval of data..

Re: View on a single table

Former Member — Thu, 18 Sep 2008 11:42:49 GMT

Ok, I know what are the fields I need to create my index.

But there are side effects affecting db performance or things like that if I create an index on a table?

Re: View on a single table

Former Member — Thu, 18 Sep 2008 12:01:24 GMT

Hello


But there are side effects affecting db performance or things like that if I create an index on a table?

Yes. For db-tables with creating new index:

1. increase the performance of READ-operations

2. decrease the performance of INSERT/MODIFY-operations

Re: View on a single table

Former Member — Thu, 18 Sep 2008 14:35:25 GMT

If the selection criteria are fixed (with constants in selection fields) the best way to proceed is to create a view, so every SELECT statement will read a subset of data, not all data in the table.

Otherwhise the best solution is to use idexes; you can see if indexes will have a good effect or not using transaction DB05 before creating any secondary index.