Skip to Content
avatar image
Former Member

View on a single table

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 ???

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Sep 18, 2008 at 10:43 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank's 😊

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

  • avatar image
    Former Member
    Sep 18, 2008 at 10:43 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Sep 18, 2008 at 11:39 AM

    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..

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Sep 18, 2008 at 02:35 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded