Eclipse Community Forums: EclipseLink » Force index in MySQL 5.1

Help

Home

Home » Eclipse Projects » EclipseLink » Force index in MySQL 5.1

Show: Today's Messages :: Show Polls :: Message Navigator

Force index in MySQL 5.1 [message #874731]

Mon, 21 May 2012 13:00

Zafiris P

Messages: 1
Registered: May 2012

Junior Member

Hi all,

I am using MySQL 5.1 and EclipseLink v2.2. I was wondering if and how I can force a generated query to use a specific index.

e.g. how can the EclipseLink query

SELECT p FROM TableX WHERE col='value';

be executed as

Select p.col,p.col2 FROM TableX FORCE INDEX (mysuperindex) WHERE col='value'

Thanks in advance

Report message to a moderator

Re: Force index in MySQL 5.1 [message #875902 is a reply to message #874731]

Wed, 23 May 2012 14:13

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

You need to use a native SQL query.

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Previous Topic:	Restore from history
Next Topic:	Duplicate column with TABLE_PER_CLASS and @OrderColumn,, bug or incorrect mapping?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 14:16:07 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter