topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Mon, 23 Apr 2007 03:13:00 GMT

hi,

if we hav 10000 records in a list.suppose we want to retrieve 6 records .,without using where clause in select statement. and also that records r stored in random places...how to retrieve without where clause.

thanx.

vijay

Re: select statement

Former Member — Mon, 23 Apr 2007 05:18:20 GMT

Hi,

You can create view with condition so that you have got all 6 record exactly.

Reg,

Hariharan Natarajan.

Re: select statement

Former Member — Mon, 23 Apr 2007 06:23:41 GMT

Hai Vijay,

If that Database table is having indxes,You can use them.

Indexes are not specified in the where clause.

Hers is sample code using indexes.Here index is on first column of Database table.

Have a look at this.

DATA:

xcarrid LIKE SPFLI-carrid,

xconnid LIKE SPFLI-connid,

xcityfrom LIKE SPFLI-cityfrom.

SELECT carrid connid cityfrom

FROM spfli

INTO (xcarrid, xconnid, xcityfrom)

WHERE carrid = 'LH ' AND cityfrom = 'FRANKFURT'

%_HINTS ORACLE 'INDEX("SPFLI" "SPFLI~001")'

WRITE: / xcarrid, xconnid, xcityfrom.

ENDSELECT.

This type of selection improves the performance a lot when the records are very high.

Hope this helps you.

Reward points if it helps you.

Regds,

Rama chary.Pammi

Re: select statement

Sathish — Tue, 24 Apr 2007 03:47:12 GMT

You can try with view maintenance...

the attached link has few suggestions which can be used..

https://wiki.sdn.sap.com/wiki/display/ABAP/ABAP+Performance