Hibernate Community • View topic - Is there any way to generate sql having OR clause in Batch

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Is there any way to generate sql having OR clause in Batch

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

shaktish_p

Post subject: Is there any way to generate sql having OR clause in Batch

Posted: Wed Dec 02, 2009 2:28 pm

Newbie

Joined: Tue Nov 10, 2009 6:31 am
Posts: 1

Hi,

Is there any way to generate sql having OR clause rather than IN clause when we set the batch size.The reason most of the database have performance issue when having IN clause in the sql statements (and i think oracle has limit to the size of the IN clasue but it is configurable) but on other hand OR clause don't have any such issues or restrictions.

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum