[sqr-users] how do i include a hint in begin-select?

[Jae Lee <leejc@appstate.edu>]

hi, all,

i deperately need to pass a hint to use a specific index for a table in 
BEGIN-SELECT, such as, in a pl/sql procedure you can:
SELECT /*+ INDEX(table name, index name) */

my query dies because of too much work load.. so i need to tell it to 
use a index for the largest table in the query.  somehow, the optimizer 
does not use this index.  because i have SQR commands to process data, i 
can't use BEGIN-SQL.

any help would be greatly appreciated!!

jae


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users