I have an Oracle and DB2 background as well. DB2 does not use hints like Oracle does. If you think about it, a hint is just tricky way to fix the Oracle optimizer when it makes a mistake.
My experience is that IBM's optimizer does not make those types of mistakes (at least not very often). The trick to good performance is to read your performance manual on tuning SQL. Understand what makes a predicate indexable and what makes it not indexable. Once you know that, you can design indexes to suite your performance needs. > -----Original Message----- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, November 15, 2001 10:35 AM > To: [EMAIL PROTECTED] > Subject: DB2EUG: Tuning SQL > > Hi > > I'm from an Oracle background where there are lots of hints that you can > put in the SQL statements for the optimizer. > > Are there any hints that you can use in DB2??? Are there any particular > methods of tuning the SQL??? > > I'd be very grateful for any input and any web sties that you could point > me towards. > > Regards > > Marcus > > > ===== > To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > For other info (and scripts), see > http://people.mn.mediaone.net/scottrmcleod ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
