View Single Post
  #1  
Old 25th July 2015, 12:55
darkhorse darkhorse is offline
Junior Member
 
Join Date: Mar 2015
Location: Mumbai
Posts: 13
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