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

["Steve Cavill" <steve.cavill@infoclarity.com.au>]

Begin-select 
/*+ INDEX(table name, index name) */ col1
Col2
End-select
Should work
-----Original Message-----
From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
[mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On Behalf 
Of Jae Lee
Sent: Wednesday, 15 February 2006 8:21 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] how do i include a hint in begin-select?

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



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