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.
CONFIDENTIALITY NOTICE. This e-mail and attachments, if any, may contain confidential information which is privileged and protected from disclosure by Federal and State
confidentiality laws rules and regulations. This e-mail and attachments, if any, are intended for the designated addressee only. If you are not the designated addressee, you
are hereby notified that any disclosure, copying, or distribution of this e-mail and its attachments, if any, may be unlawful and may subject you to legal consequences. If you
have received this e-mail and attachments in error, please contact Independent Health immediately at (716) 631-3001 and delete the e-mail and its attachments from your
computer. Thank you for your attention
>>> 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
> 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.
This archive was generated by hypermail 2.0.0 : Fri May 13 2005 - 13:35:12 EDT