Forum Stats

  • 3,851,381 Users
  • 2,263,969 Discussions
  • 7,904,691 Comments

Discussions

Edit to Pref.txt file ?

David T
David T Member Posts: 6 Blue Ribbon
edited Jan 4, 2016 10:43AM in Discoverer

Hello, I was hoping for some help to speed up a Discoverer report used by our client.

This is apparently a bit slow. I having found the following at the start of SQL Inspector:

SELECT /*+NOREWRITE*/

I have also found a Forum entry from a Michael Armstrong-Smith which suggests this could slow our client's reports

To remedy, he recommended an edit to pref.txt

Under the section [Database] he recommends:

UseNoRewriteHint=0

Our DBA informs that this hint is not stated in our pref.txt file

Would adding this, in anyway help to speed up our slow running report?

Thanks in advance. Please excuse my ponderous exposition, this is a bit outside my general role in Application Support

David Tarren

Answers

This discussion has been closed.