sql statement and sorted/hashed table

[Former Member]

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

[Former Member]

hi

this thread will solve ur query:

The performance of SELECTS differs from case to case.

use st05 and se30 to probe in to performance issues.

**reward if helpful

regards,

madhu

[Former Member]

Hi Charles,

I cannot answer your answers directly, but i can guide you to know the better of the two alternatives.

Write the code using the two techniques.

Go to se30. Click the Tips and Tricks button on the appl toolbar.

paste your codes in the spplit screen editor and run them both.

You can see the performance statistics for both the methods, later you can find which is better for your case.

Regards,

Ravi