View Single Post
Old 25th July 2015, 11:55
darkhorse darkhorse is offline
Junior Member
Join Date: Mar 2015
Location: Mumbai
Posts: 14
darkhorse is on a distinguished road
Baan: FP3,FP6,FP8 - DB: DB2,SQL - OS: UNIX
Is hint Ineffective on DB2
Baan: ERP LN 6.1 FP6
DB: DB2 7 FP6
OS: Other/Unknown
C/S: None/Unknown

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.
Reply With Quote