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

["Peter Burton" <Peter_Burton@hyperion.com>]

Jae,

Begin-Select
/*+ INDEX(table, index) */
Col1
Col2
..
 From table
..
End-Selecy

Peter

-----Original Message-----
From: sqr-users-bounces+peter_burton=hyperion.com@sqrug.org
[mailto:sqr-users-bounces+peter_burton=hyperion.com@sqrug.org] On Behalf
Of Jae Lee
Sent: Tuesday, February 14, 2006 4:21 PM
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


If you have received this e-mail in error, please delete it and notify the 
sender as soon as possible. The contents of this e-mail may be confidential and 
the unauthorized use, copying, or dissemination of it and any attachments to 
it, is prohibited.

Internet communications are not secure and Hyperion does not, therefore, accept 
legal responsibility for the contents of this message nor for any damage caused 
by viruses. The views expressed here do not necessarily represent those of 
Hyperion.

For more information about Hyperion, please visit our Web site at 
www.hyperion.com



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