You are right. My bad... Yeah, SQLTemplate is the way to go then.
Andrus
> Hi Andrus,
>
> That was the different table, and problem was resolved, but this is a
> differnet table. that has so many rows, for better performance we
> indexing the err_id column. I think we have to use SQLTemplate for that
> type of query.
>
> Thanks
> sami
>
>>>> andru..bjectstyle.org 05/13/05 12:20PM >>>
> 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 - 13:37:47 EDT