Add index to SET_ID column in NEWS_CONFIGURATION
Closed this issue · 1 comments
bjagg commented
Report from TAMU that with Oracle db, index on SET_ID is not created. This causes performance issues.
bjagg commented
NewsConfiguration.hbm.xml
<many-to-one
name="newsSet"
class="org.jasig.portlet.newsreader.NewsSet"
cascade="merge, persist, refresh" lazy="false">
<column name="SET_ID" index="SET_ID_IDX" />
</many-to-one>