help in select performance

[Former Member]

hi,

i need to select data from table catsdb but i have lot of

recored like 2,000.000 records ,

i see that this table have secondary index ,

maybe this can help ?

how i use it?

Best Regards

[Former Member]

What do you want to do?

Rob

[Former Member]

Hi,

SELECT required data

FROM catsdb

APPENDING TABLE ITAB

PACKAGE SIZE 30000.

Write your functionality if you want to do any checks

with ITAB data.

ENDSELECT.

Now it never go for Dump .Adjust(increase/Decrease) Package size according to performance.

[Former Member]

If you don't specfiy what you want to select, then nobody undertsand why you need the secondary key. Maybe the primary is also o.k.

Just write your select and use all information in the where condition which you have.

It will always work, but if will only perform well, if you have the first fields or all of an index in the WHERE condition.

You don't need a package size, the table has 2.000.000 records, but I hope you want to select much less.

Siegfried

[Former Member]

hi Ricardo,

Try including all the fields of secondary index in the where condition of your select statement... This works ..

Regards,

Santosh

[Former Member]

Hi

Try using all the fields of secondary index in same sequence and do not use negative condition in your where condition

Use the sequence of the select in same position as in table

Regards

Shiva