avatar image
Former Member

SELECT with hint and Client Specified, 7.40

a SELECT in ABAP 7.40:

I need to add an Oracle hint, and also"CLIENT SPECIFIED";

yet, when adding "CLIENT SPECIFIED" then the hint is gone (is not run on the database anymore.

Basically I need to run a full-table-scan select on a database table with more than 5.000.000.000 datasets, and field MANDT has one value. I need the Oracle-hint to parallelize this. Plus I need to get rid of the WHERE MANDT EQ 'NNN' addition, because there is only one MANDT.

Has anyone done this? (Will it be possible in 7.50?)

Going of a tangent, I would like to add a hint to parallelize a DELETE DB-Table command, but there seem to be no hints allowed there in ABAP (Will 7.50 allow it?)

AHGA

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 28, 2017 at 02:18 PM

    Regarding the last question, in DELETE the hint is placed behind WHERE:

    https://help.sap.com/http.svc/rc/abapdocu_751_index_htm/7.51/en-US/index.htm?file=abenosql_db_hints.htm

    Since many releases.

    Docu with apparent translation error, correction triggered ...

    Add comment
    10|10000 characters needed characters exceeded

Skip to Content