Skip to Content
0
Former Member
Apr 09, 2007 at 08:51 AM

sql statement and sorted/hashed table

68 Views

Will a select into a sorted or hashed table cause performance issue?

or is it better to select into a standard table. then later insert into another temporally sorted/hashed table?

eg. select into standard_itab.

sort standard_itab by a b.

sorted_itab[] = standard_itab[]. "sorted itab with fields a and b.

Thanks

Message was edited by:

Charles Liu