Indexhints: Going back to old situation.

In 4.0 SP3 update 6, C/SIDE enables indexhinting by default.  This is quite a hot topic in the community at the moment:

• Mibuso
• Sustained engineering team Blog
• And also some things on my blog... .

Now, it is quite easy to go to the old situation, where indexhinting was not default. 

What do you need to do:

In Enterprise Manager (SQL2000) or SQL Server Management Console, create the a table with following statement:

CREATE TABLE [$ndo$dbconfig] (config VARCHAR(512) NOT NULL)

GRANT SELECT ON [$ndo$dbconfig] TO public

With this next statement, you disable the indexhints:

INSERT INTO [$ndo$dbconfig]

VALUES ('IndexHint=No')

Now, the old situation is restored.  If you want, can add indexhinting one by one by statements like:

INSERT INTO [$ndo$dbconfig]

VALUES ('IndexHint=Yes;Company="DEFAULT COMPANY";Table="Vendor";Key="Search Name";Search Method="-+$";Index=1')

For this, just read the guidelines of the blog mentioned above.

You see that it's quite simple. 

I Hope this article is useful to you.