It looks like you're new here. Sign in or register to get started.
Keyword Options for select Statements Keyword
Fetches the first selected record faster than the remaining selected records.
Returns only the first selected record.
Selects records for updating.
Specifies that the Dynamics AX runtime should not execute the statement immediately because the records are required only by some other operation.
Forces the Dynamics AX runtime to generate a query with placeholder field constraints. For example, the query generated for the preceding code example looks like this: select * from myTable where myField1=?. Database query plans are reused when this option is specified. This is the default option for select statements that do not join table records. This keyword cannot be used with the forceliterals keyword.
Forces the Dynamics AX runtime to generate a query with the specified field constraints. For example, the query generated for the preceding code example looks like this: select * from myTable where myField1='value'. Database query plans are not reused when this option is specified. This keyword cannot be used with the forceplaceholders keyword.
Forces the Microsoft SQL Server query processor to access tables in the order in which they are specified in the query. (No effect on Oracle.)
Forces the SQL Server query processor to use a nested-loop algorithm for table join operations. Other join algorithms, such as hash-join and merge-join algorithms, are therefore not considered by the query processor.
Returns records in reverse of the select order.
The following code example demonstrates how a table index clause is used to suggest the index that a database server should use when querying tables. The Dynamics AX runtime appends an order by clause and the index fields to the first select statement's database query. Records are thus ordered by the index. The Dynamics AX runtime inserts an optional query hint into the second select statement's database query.