Re: Slow running procedures

I suggest you try coding a hint naming the index that you want the call to use. You should be able to find the exact syntax in the Application Developers Guide. It is something like /*+ INDEX_ASC(tablename index_name) */. Hints require exact typing of the '/*+ ' or they are iognored. This is the syntax for a range scan so drop the '_ASC' when you just want to point to a specific index.

Mark -- No clever disclaimer. Received on Sat Mar 25 1995 - 23:27:54 CET