Migrating from Oracle to SQL Server - SQL HINTS

[Former Member]

We are migrating an SAP landscape from HP-UX / Oracle to Windows / SQL Server. We have numerous custom programs with OPEN SQL Hint statements of the form:

select a_{qmnum a}kunum a_{objnr a}zztaxtype a~zzservcenter

a_{zzassmpriok a}zzaudittype a~zzdr840dt

into corresponding fields of table lt_qmel

from qmel as a

inner join ihpa as b

on a_{objnr = b}objnr

where a~qmart IN ('Z7','Z8','Z9','ZU','ZD')

and b~parnr = sy-uname

*%_hints oracle*

*'INDEX("&TABLE&" "IHPA_{P" "IHPA}P")'.*

Question: What is the best way to make these SQL statements compatible with SQL Server?

Thanks

[lbreddemann]

>

> We are migrating an SAP landscape from HP-UX / Oracle to Windows / SQL Server. We have numerous custom programs with OPEN SQL Hint statements of the form:

> Question: What is the best way to make these SQL statements compatible with SQL Server?

Hi Paul,

as hints are highly database specific it may well be that you won't need them for your new DBMS anymore.

In any case you've to review them one-by-one to check the execution plan of the queries without a hint.

A general "migration of hints" is neither possible nor sensible.

regards,

Lars