Hello,

I have spend some time searching the forums and Google... But I found nothing.

I have a table named 'Log'... Each time I doing something I insert a line saying what have been done by Who/When and What.

For example, when I am inserting an user I have a row like that:

<code>
NEWUSER date createdUser_id
</code>

Note that a row reference entitis like the created user...

The problem is that I have a lot of INSERT in this table and hibernates created an index for each column referencing another entity.

For example, this time I have an index for the createdUser_id column.

My questions are:

1°) is it possible to disable INDEX here, because, the insert is longuer (I think) and I will never make some search in the Log table or the time won't be a problem..

2°) Is it possible to give a pleasant name to created indexes ?


Thanks a lot.

Best Regards,

Frederic

No, I don' think so. Hibernate only creates an index if you have told Hibernate to do so. For example, with index, unique or any other related tag attribute.

It could be that the database you are using requires an index on foreign-key columns. I know that MySQL has this requirement, and automatically creates an index if one doesn't already exists.