Optimized method

[Former Member]

Hello all!

I am running a select on a TRDIR which is taking hell lot of time. Is there any other "optimized" way of doing it?

Puru

[Former Member]

Hello Puru,

Create secondary indexes for the fields for which you are passing in the where clause. It will optimize the performance.

Thanks,

Krishnakumar

[Simha_]

Hi,

Use table REPOSRC instaead of that.

and it is also taking time..

create the indexess on the table..

This will solve ur problem..

Cheers,

Simha.

[Former Member]

Hi,

can you show your select. and are you selecting all the entries or you have any specific conditions..

Regards

vijay

[Former Member]

Hello Puru,

Use Sorted type internal tables.

If useful reward.

Vasanth

[Former Member]

Hello Puru,

Create secondary indexes for the fields for which you are passing in the where clause. It will optimize the performance.

Thanks,

Krishnakumar

[anversha_s]

hi,

some sugestions

************************

1. if u r using select * , avoid it. fetch the fields only u required.

2. give secondary index to the fields in the where clause.

3. after fetching into the internal tabel , sort the table.

4. avoid INTO CORESSPONDING in ur select query. it will take lot of time.

all the best.

if hlped rwrd points,

Rgds

anver

[Former Member]

Hello Puru,

Use Sorted type internal tables.

If useful reward.

Vasanth