Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

sql statement and sorted/hashed table

Former Member
0 Kudos

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

2 REPLIES 2

Former Member
0 Kudos

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_member181962
Active Contributor
0 Kudos

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