Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

hi ,

How create index oracle with hibernate in mapping file ?

(An index is a performance-tuning method of allowing faster retrieval of records. An index creates an entry for each value that appears in the indexed columns. )

The syntax for creating a index with oracle sql is:
CREATE [UNIQUE] INDEX index_name
ON table_name (column1, column2, . column_n)

how do that with hibernate ?

thanks u ,


Hibernate version: 3.0

Mapping documents: 3.0

Name and version of the database you are using: oracle 8.1

That's an operation you'd usually perform when first creating the db. Why not just run the SQL to create the indexes from SQL Plus, which is included with Oracle.

i hope an other solution, it's not correct for me to do something by hibernate and something else by sql , it's all by hibernate or nothing !! :0 but if i haven't other solution i do that, thks.

See 21.1.1. Customizing the schema:
http://www.hibernate.org/hib_docs/v3/re ... guide-s1-2

"Some tags accept an index attribute for specifying the name of an index for that column. [...]"

Example:


Note that it doesn't need to be a multi-column index.

Best regards
Sven

This is a very, very bad philosophy. Use the right tool for the job.

Ah ... i don't know... i think its strange to use an techno for do something and want you have any problem you do that with another techno... but i remember what u say , you have more experience of me i'am so young !! :)

ah and thanks you sven i go to read this article.