Skip to main content

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.

Jump to: navigation, search

Difference between revisions of "EclipseLink/DesignDocs/283430"

(New page: <div style="margin:5px;float:right;border:1px solid #000000;padding:5px">__TOC__</div> = Design Specification: Indexes = [http://bugs.eclipse.org/283430 ER 283430] [[Talk:EclipseLink/Des...)
 
(API)
Line 43: Line 43:
  
 
* Index
 
* Index
* @Index(name, unique, @Columns[])
+
* @Index(name, table, unique, columns[])
 
* @Indexes
 
* @Indexes
  

Revision as of 16:06, 25 August 2010

Design Specification: Indexes

ER 283430

Feedback

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" 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.

Back to the top