select data from database tables with high performance

[Former Member]

hi all,

how to select data from different database tables with high performance.

im using for all entries instead of inner joins, even though burden on data base tables is going very high ( 90 % in se30)

hw to increase the performance.

kindly, reply.

thnks

[Former Member]

Hi,

I think may be large amount of data vl b the problem for tht.

U can run tht one in back ground also

or

U can use secondary index concept in select query.

Use secondary index on fields wher u used in where condition part of select query.

I think it vl reduce.

Thanks & Regards,

R.P.Sastry

[Former Member]

Hi,

Check if you are selecting the required data only.

Rectify the where clause .

You can use the selection by primary key filds if possible.

if records are in millions then go for secondary indexes.

[Former Member]

Also Check you are not using open sql much like distict order by group by , use abap techniques on internal table to acive the same.

also Dont use select endselect.

if possible use up to n rows claus....

taht will limit the data base hits.

also dont run select in siode any loops.

i guess these are some of the trics oyu can use to avoid frequent DATA BASE HITS AND ABVOID THE DATA BASE LAOD.

[Former Member]

hi,

do like this....

1. select all keys for the selection criteria , because if some cases we generally doesnt use all the keys but it is very important.

2. sort table with binary search is must.

3. get the required fields only and not all the fields for selection with higher structure.

4 . avoid looping in side the select .

5. use select upto 1 row rather than select single.

it may be useful ,

regards,

venkat.