index « MySQL « JPA Q&A

  1. JPA Q&A
  2. MySQL
  3. index




1. Using MySQL Index for foreign Keys with Hibernate    stackoverflow.com

Our current database (MySQL) already has Indexes for its foreign keys since these use InnoDB, which (afaik) automatically generates IndexTables for foreign keys. Hibernate wasnt used to create these tables. So ...

2. How to create indexes on multiple columns    stackoverflow.com

We have the following entity relationships where a User belongs to a particular Organization. My queries either look like "select * from User where org=:org" or "select * from User where ...

3. ZIP retrieval from database - how to optimize it with indexes    stackoverflow.com

I got following database:
http://sourceforge.net/projects/zips/ What I would like to do is optimize it. Basically when user enters ZIP code I want to retrieve Long and Lat. I use Spring > ...

4. Index creation on MySQL fails    forum.hibernate.org

5. using MySQL's IGNORE INDEX through Hibernate    forum.hibernate.org

I'm using Hibernate 3.2 and MySQL5.0 and need to use the 'IGNORE INDEX (indexName)' syntax because MySQL's query optimizer is choosing the wrong index for a number of queries. I have tried to use Hibernate's Dialect.registerKeyword and registerFunction methods to enable this, but I haven't had any luck. I keep getting 'unexpected token: IGNORE near line 1, column 57' errors. Is ...