Ask the Experts - 74

Posted by Nitin Pai
January 30th, 2009

Hi I’d like to ask expert about ” hint in peoplesoft”. Except can choose “first_rows”, “all_rows”, can the sql be added the hint using index?

Example, /*+ index (tb_name index_name )*/

Thanks,

Thanks for posting your question!

Yes, you can use any valid Oracle supported HINT if you have Oracle DB for your PeopleSoft environment.

Thanks
Nitin Pai

Comments (0)