topic Re: SELECT syntax for speed in Application Development and Automation Discussions

SELECT syntax for speed

Former Member — Thu, 23 Aug 2018 16:30:12 GMT

What is faster in a SELECT....WHERE statement?

objnr+0(2) IN ('PR','NV')

(objnr LIKE 'PR%' OR objnr LIKE 'NV%')

Re: SELECT syntax for speed

roberto_forti — Thu, 23 Aug 2018 17:00:43 GMT

Hi, consider working with below transactions to analyze it

1. SE30 or SAT (Runtime Analysis) transaction

2. ST05 - SQL Trace (Performance Trace) transaction

Attached documentation about SQL Trace

https://wiki.scn.sap.com/wiki/display/SAPSQL/How+to+run+transaction+st05+to+trace+a+program%2C+transaction+or+user+execution

Regards,

Re: SELECT syntax for speed

matt — Thu, 23 Aug 2018 19:39:08 GMT

Did you consider writing a couple of programs to find out? And then maybe publishing a blog with the use case, why it's important to you and the results?

Re: SELECT syntax for speed

roberto_forti — Thu, 23 Aug 2018 21:07:54 GMT

Hi Ken Melching, let us know the results. Regards

Re: SELECT syntax for speed

Sandra_Rossi — Thu, 23 Aug 2018 21:58:16 GMT

It depends on the type of database you are using, not ABAP.

Is objnr+0(2) permitted in OpenSQL now?

Re: SELECT syntax for speed

P14397410 — Fri, 24 Aug 2018 14:24:33 GMT

Ken,

objnr+0(2) IN ('PR','NV')

Above syntax is disallowed (at least when Oracle is the database). If that is allowed in your installation, it should be easy to write a test program and check for yourself. You can use GET TIME STAMP statement to measure the time.

DATA: l_timestamp_1 TYPE timestampl,
      l_timestamp_2 TYPE timestampl,
      l_time        TYPE timestampl,

      t_covp        TYPE STANDARD TABLE OF covp.

GET TIME STAMP FIELD l_timestamp_1.

SELECT  *
INTO   TABLE t_covp
FROM   covp
UP TO  100 ROWS
WHERE  objnr LIKE 'PR%' OR objnr LIKE 'NV%'.

GET TIME STAMP FIELD l_timestamp_2.

l_time = l_timestamp_2 - l_timestamp_1.
WRITE: / l_timestamp_1, / l_timestamp_2, / l_time.