Creating Indexes for Queries
When using joined queries, Aurora automatically creates indexes on the columns used in the join.
To create indexes on other queries (e.g., simple queries without joins or more complex queries with joins) or for other columns, insert a standard SQL "CREATE INDEX" statement at the beginning of the query, using a unique ID for each index being created.
A standard SQL "CREATE INDEX" statement looks like the following:
CREATE INDEX id30 ON _Input_Resources1 (Capacity)
Where id30 is the unique ID, _Input_Resources1 is the table, and Capacity is the column.
This statement can be inserted at the beginning of any Aurora query or a query created with SQL Manager, etc.
To create indexes automatically on the output database, set them up in a query (no actual query is needed, just insert in the query box), save the query in a custom template (see Using Quick Views), and set the custom Quick Views to automatically load at the end of the run (see Simulation Options --> Post Simulation Actions).
Productivity Tools
Creating Indexes for Queries
