Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performance of SELECT Statements

Hi All,

I have a small confusion.

Consider these 3 statements :

A.

SELECT * from table1 where {conditions based on primary key}.

exit.

Endselect.

B.

SELECT SINGLE * from table1 where {conditions based on primary key}.

C.

SELECT upto 1 rows from table1 where {conditions based on primary key}.

Considering that table1 has more than 1 primary keys,Which statement gives the best peformance when

1.All the keys are used in the where condition.

2.Only a few keys are used in the where condition

Thanks in advance.

Hari

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question