If you have to do this type of optimizations, you are stuck with
SQLTemplate. You didn't mention it in your original message
(http://objectstyle.org/cayenne/lists/cayenne-user/2005/05/0074.html)
Andrus
> Hi All
> String selectSql = "SELECT /*+ INDEX(e err_id) */ E.ERR_ID,
> E.ERR_COL_NME," +
> "E.ERR_COL_VAL, E.ETL_MAP_NME, E.TBL_NME, E.KEY_VALS, E.ERR_TMSTP,"
> + "E.ERR_MSG_TXT, E.ERROR_FLAG, E.ERR_CD, ERR_S.ERR_STAT,
> ERR_S.CURR_ROW " + "FROM IHA.ERROR_INFO E, IHA.ERR_STAT ERR_S " +
> "where E.ERR_ID = ERR_S.ERR_ID";
>
> above code using oracle Hint to err_id for fast retrival .
> How can we do this kind of query in SelectQuery or we need to use
> SQLTemplates only.
>
>
> Thanks
> sami
>
This archive was generated by hypermail 2.0.0 : Fri May 13 2005 - 12:20:59 EDT