topic Re: sql statement and sorted/hashed table in Application Development and Automation Discussions

sql statement and sorted/hashed table

Former Member — Mon, 09 Apr 2007 08:51:31 GMT

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 — Mon, 09 Apr 2007 08:54:42 GMT

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 — Mon, 09 Apr 2007 08:54:50 GMT

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