Hibernate set index on multiple columns while one of the columns is the ID

Question

Is it possible to set index of multiple columns while the one of columns is the Primary Key

score 0 · Accepted Answer · edited May 23 '17 at 12:21

0

See this post (googled java hibernate jpa index):

Then see that (googled java hibernate jpa index composite):

edited May 23 '17 at 12:21

Community

answered Jul 09 '13 at 13:29

surfealokesea

I know that primary key is already index. my question is if I can put a new index which include two or more columns while one of them is the primary key ? – john Smith Jul 09 '13 at 13:31
2

@johnSmith: I'm not sure whether you read them through. Last link shows how to define multiple column indexes. It doesn't care whether one of them is primary key or not. You can use it. – GokcenG Jul 09 '13 at 14:56

score 0 · Answer 2 · answered Feb 21 '19 at 13:49

0

You can do it like this:

<id name="id" type="NumericInteger"> <column name="ID" index="INDEX01"/> </id>

The key is to remove column="ID"  as property of Node <id> and place it as <column> definition instead

answered Feb 21 '19 at 13:49

Piotrjavspl

2 Answers2