Does ArcGIS Server support Hints in Definition Queries?
Are you referring to Hint (SQL) - Wikipedia ?
Please provide more details. Which version of ArcGIS? Which RDBMS? Enterprise-enabled geodatabase or non-GDB? Registered feature class or query layer? What has your experimentation indicated? Just so we're clear here, it isn't up to ArcGIS to support the SQL language in databases. Its sole responsibility is to turn over SQL strings to the database, and process the results. You could certainly use SDETRACE or SDEINTERCEPT to detect whether the embedded comments which are hints are forwarded to the SQL engine. Whether the optimizer chooses to use them is completely out of Esri's hands.
We use ArcGIS 10.2.2 / Oracle 126.96.36.199 with an enterpsie-enabled geodatabase and feature classes.
I get the following exception when i try to at my hint to the expression: Invalid 'definitionExpression' specified for dynamic layer...The dynamic layer definition contains something like: definitionExpression" :"PKEY IN (SELECT /*+ hash_sj */ PKEY FROM TABLE)".
I'll try to check SDETRACE and SDEINTERCEPT. thanks
Retrieving data ...