[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Inserting Oracle optimizer hints into queries
warmachine
do-not-reply at jboss.com
Wed Mar 14 11:47:20 EDT 2007
I have two JBossQL queries, one dynamic, that searches a huge Oracle table. Obviously, I use indices but the Oracle SQL optimizer thinks it's better to do a full table scan than use these indices. I kid you not. Tests demonstrate it's the worst plan.
Rather than messing around the optimizer, which will degrade other queries, it'll be better to insert an optimizer hint, such as /*+ RULES */ into the generated SQL and override the brain damage. However, I can't generate SQL, JBoss is doing that for me from the JBossQL. Is there anyway I can get something inserted into generated SQL queries?
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4027994#4027994
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4027994
More information about the jboss-user
mailing list