Hi Pando,
Thanks... this is what I was thinking. But this is sent by one of our customers. I want to do a good job for them.
What do you think, where should I start tuining these ?? Do I have to scan through all queries running behind for this part ?

The indexes recommended are all mangled !!!

Is logging really required, if so should I put them on all ?

Am I right about putting FK column 1st in indexes ?


thanks a lot again

Sonali