SQLIndex blank for NAV2009?

Alex_Chow

Is there a reason why all SQLIndex for all the keys are blank? Do we need to do optimization on our own? Or does it come pre-optimized?

Or does MSFT leaves it up to the NSC to do the optimization for SQL for NAV?

ara3n

they found out that having differeing sql index and having the order by clause different causes performance decrease. so they removed them all.

kine

Yes, it is on NSC to optimize each system case by case, because each case needs different indexes, it is hard to opt something in generally.

garak

You must optimize the indexes self. Because it can be different in each customer system

(Hannover -15°C, I'm cold)

DenSter

I thought they did this in 5.0 SP1 already.

kine

They did and removed it again... :-)

DenSter

What I mean is I thought they removed all SQLIndex values in 5.0 SP1, so I was expecting not to have them in 2009.

ara3n

DenSter wrote:

What I mean is I thought they removed all SQLIndex values in 5.0 SP1, so I was expecting not to have them in 2009.

Yes they did remove them in 5.0 sp1, I forgot to mention it in my original post.