Relational Engine

This section discusses the new and revised functionality to support the Relational Engine.

A table subquery within a SELECT now supports the ORDER BY clause. A common use for this feature is to include a TOP clause in the SELECT list to return the first number of desired rows. ORDER BY clauses are allowed in table subqueries only, not in any other type of subquery clause.

See SELECT in SQL Engine Reference.

CREATE INDEX Using Specified Index Number

CREATE INDEX now supports the specification of an index number with the USING index_number clause. This functionality is particularly useful when the data file for a table is accessed directly through the MicroKernel Engine as well as through the Relational Engine. You can include the USING index_number clause with CREATE INDEX and CREATE INDEX IN DICTIONARY.

See CREATE INDEX in SQL Engine Reference.