Oracle Hint

From: Sami Mohammed (SMOHAMME..ndependenthealth.com)
Date: Fri May 13 2005 - 12:14:17 EDT

  • Next message: Andrus Adamchik: "Re: Oracle Hint"

    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

    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

    This archive was generated by hypermail 2.0.0 : Fri May 13 2005 - 12:14:42 EDT