Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
EclipseLink/DesignDocs/283430
< EclipseLink | DesignDocs
Design Specification: Indexes
Document History
| Date | Author | Version Description & Notes |
|---|---|---|
| 2010-08-25 | James | 0.1 Draft |
Project overview
Concepts
Requirements
Design Constraints
Functionality
Testing
Define indexes for some test schemas. Need to test on all databases.
API
- Index
- @Index(name, table, unique, columns[])
- @Indexes
Config files
- orm.xml
<index name="EMP_NAME" table="EMPLOYEE" unique="true"> <column name="F_NAME"/> <column name="L_NAME"/> </index>
Documentation
Should be documented under extended annotations, and schema generation.
Open Issues
| Issue # | Owner | Description / Notes |
|---|---|---|
| 1 | What databases support indexes, do any use a different syntax? |
Decisions
| Issue # | Description / Notes | Decision |
|---|
Future Considerations
- Other DDL options.