topic Re: database table sorting in Application Development and Automation Discussions

database table sorting

Former Member — Sat, 26 Jan 2008 04:51:24 GMT

hi everyone:

I want to sort the database talbe record.in native sql statements,what statement I

can use.can sort statement work?

thanks a lot

Re: database table sorting

former_member194669 — Sat, 26 Jan 2008 04:52:47 GMT

Please check SELECT with ORDER BY option

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3a53358411d1829f0000e829fbfe/content.htm

a®s

Edited by: a®s on Jan 26, 2008 12:01 AM

Re: database table sorting

Former Member — Sat, 26 Jan 2008 05:03:02 GMT

I only want to sort the database record,not fetch data,no matter how ,I will try your idea,thanks

Re: database table sorting

former_member194669 — Sat, 26 Jan 2008 05:07:34 GMT

database sort is done by system by primary key , if you want to sort the database records other than primary key then you need to use for secondary index.

a®

Re: database table sorting

Former Member — Sat, 26 Jan 2008 05:18:51 GMT

I have created a secondary index,but the result is the same as the old version,

I think native sql will be helpful,but i donot know what should i do? my background

datasystem is oracle

Re: database table sorting

former_member194669 — Sat, 26 Jan 2008 05:28:29 GMT

Please check this thread

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/content.htm

a®

Re: database table sorting

Former Member — Thu, 13 Mar 2008 08:47:59 GMT

Hi,

why want you do that? By design the order of records in a table doesn't matter.

If you want to make use of the records you have to SELECT them.

When you SELECT them you can have an ORDER BY, voila it's sorted.

Let's say you inserted a bunch of rows ORDERED into the table. Well it's fine...

You do a SELECT * from table

The question is: will you get the rows ordered? The answer: yes, no, maybe

You have to SELECT and ORDER BY to be sure to have the table ordered.

I.E. databases are storing rows in a storage-efficient way (ORACLE uses so-called blocks for that).

When you SELECT it visits all blocks that contain the rows and give them back in a efficient (not ordererd ) way back. The database uses a Cost based optimizer (CBO) to do that.

The result set can than be ordered by the query plan given by the CBO.

Hoe that helps