[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [eclipselink-users] No index on the foreign key problem in Oracle
|
The schema EclipseLink can auto generate is mainly for use in development, a
production schema should probably be designed by a dba. There is no index
support currently in EclipseLink other than executing DDL native queries, I
agree this would be useful, please log an enhancement for this.
Syvalta wrote:
>
> Hi,
>
> I had some problems with deadlocks in Oracle 10. The cause was that there
> was no index on the foreign key (more details in:
> http://asktom.oracle.com/tkyte/unindex/). The question is, could
> EclipseLink include such an index automatically when creating the ddl?
>
> The problem occurs with ManyToMany and one-way ManyToOne relations, i.e.
> when there is an additional mapping table:
>
> A.id <-- A_B.a_id
> A_B.b_id --> B.id
>
> In this case index is created automatically by Oracle for (A_B.a_id,
> A_B.b_id), leaving A_B.b_id unindexed. Of course the index can be created
> manually, but it would be nice if it could be created automatically (at
> least optionally).
>
> If this is reasonable I'll be glad to submit a RFE to Bugzilla.
>
>
>
-----
---
http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland
http://www.eclipse.org/eclipselink/
EclipseLink , http://www.oracle.com/technology/products/ias/toplink/
TopLink
Wiki: http://wiki.eclipse.org/EclipseLink EclipseLink ,
http://wiki.oracle.com/page/TopLink TopLink
Forums: http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink ,
http://www.nabble.com/EclipseLink-f26430.html EclipseLink
Book: http://en.wikibooks.org/wiki/Java_Persistence Java Persistence
--
View this message in context: http://www.nabble.com/No-index-on-the-foreign-key-problem-in-Oracle-tp19873256p19879434.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.