topic Re: Select for a hashed table in Application Development and Automation Discussions

Select for a hashed table

Former Member — Tue, 22 Aug 2006 06:02:42 GMT

Hi All,

This is a repost but this time Ill be specific.

How do I select from a table into a hashed table faster without using "select distinct"? my primary concern is the speed of the select statement, and im afraid I cannot get rid of the hashed table destination.

Thanks,

Kenny

Re: Select for a hashed table

Former Member — Tue, 22 Aug 2006 06:06:40 GMT

[code]select field1 field2 into table itab

from dbtab where cond.

Hashed tables don't take any duplicate record,

hence, we have to specify all the KEY FIELDS,when declaring the table.

Re: Select for a hashed table

Former Member — Tue, 22 Aug 2006 06:13:48 GMT

Thanks Kishan,

Problem is Im only after one field from the dbtab. And this is not a unique key, thats why Im using select distinct now. Therefore, I am limited to it for selecting Unique rows. Please help.

Thanks.

Kenny

Re: Select for a hashed table

Former Member — Tue, 22 Aug 2006 07:34:18 GMT

HI Kenny,

HASHED TABLE:

There is no default setting for hashed tables. However, you must define a UNIQUE key. The NON-UNIQUE addition is not permitted.

You cannot avoid this statement. May be the alternative is You have to use SORTED table with NON-UNIQUE option and then apply DELETE ADJACENT DUPLICATES, in this way you can have unique values for your itab.

Regards,

Raghav