topic Re: help in select performance in Application Development and Automation Discussions

help in select performance

Former Member — Wed, 20 Feb 2008 20:49:09 GMT

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 — Wed, 20 Feb 2008 21:17:44 GMT

What do you want to do?

Rob

Former Member — Thu, 21 Feb 2008 05:17:52 GMT

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 — Thu, 21 Feb 2008 09:32:47 GMT

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 — Thu, 21 Feb 2008 09:37:49 GMT

hi Ricardo,

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

Regards,

Santosh

Former Member — Fri, 22 Feb 2008 06:16:34 GMT

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