package size

[Former Member]

hi experts,

please help in usage of package size in select query with where clouses

without for all enteries

regards

prashant

[Former Member]

'Package size' addition of SELECT statement will be used to restrict the number of records while fetching the data from the database table.

You can check [this link|;

Edited by: Satya suresh Donepudi on Mar 12, 2009 2:59 AM

[Former Member]

Hi,

Please check this link

it would helpful

Thanks and regards

Durga.K

[Former Member]

Hi,

Check this thread

Regards,

Jyothi CH.

[Former Member]

Hi Prashant,

Package size option in select query is useful in multiple cases:

- When the number of records accessed by the select query for the given where clause are very large and it may slow down the performance of the program. In this case package size option is used such that data is fetched in multiple hits.

- If the program is checking for a particular record from the database table having very large number of records without knowing the actual key. In this case package size can be used such that we can check for the existence of the required record after each fetching and can be exited from loop immediately after finding the record.

Thanks,

Sankar