enhance the performance of cluster table in code

[Former Member]

hi all ,

i am using a cluster table BSET in my selection . it is giving a performance issue . is there any ways of enhancing the performance other than key field use.

Thanks in advance

[Former Member]

Nope.

Rob

[Former Member]

Hello,

Try using package in select query.

Regards,

Neelambari

[Former Member]

>

> Try using package in select query.

How would that help??

[Former Member]

will package increase the performance.

i am not getting any dump issues related to time out. only it is taking more time.

is there any need of package.

[JozsefSzikszai]

what do you select from BSET? and how do you select? probably if you copy your code here we could help more...

[Former Member]

PACKAGE SIZE might help if you had memory problems, but since it is used in a SELECT/ENDSELECT construct it will tend to be slower.

Rob

[Former Member]

use of cursor helped