Is hint Ineffective on DB2
Baan: ERP LN 6.1 FP6
DB: DB2 7 FP6
Hi Every one ,
I was encountering a performance issue when opening a session.
I took CGP of that particular session in order to find out the root cause.
In that, I found one Query taking most of the time in which Index Hint was being used since secondary index were used.
I wonder on SQL server that query works fine with hint reducing the time.
Thus I wanted to have clearer view on does Hint effective depends on SQL Server, DB2 etc.
Waiting for your all valuable suggestion.
To be successful, the first thing to do is fall in love with your work.