[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Efficient Selects
- Subject: Efficient Selects
- From: "Cadenas, Maria (MT)" <MCadenas@DOW.COM>
- Date: Tue, 30 Jan 2001 13:23:59 -0600
Question:
How can I get comments sent to the database in order to help the database be
more efficient by submitting, in comments, Index hints?
For example:
begin-SELECT
#ifdef DB2ALL
/*+ INDEX(DB PS_DEDUCTION_BAL)*/ <---THIS BEING THE HINT IN COMMENTS TO BE
SENT TO THE DATABASE
DECIMAL(SUM(EB.GRS_YTD),15,3) &EB.Grs_YTD
#else
SUM(EB.GRS_YTD) &EB.Grs_YTD
#endif
FROM PS_EARNINGS_BAL EB
any help most appreciated