Ninja's_RGR'us (2/8/2011)
Yes you're right on the script part.Like I said I NEVER leave the keys out of the dev phase.
And then I'm good enough at tuning that I don't need to take 'em. So I'd start there.
One more thing to consider is that those FKS are self documenting the DB for you. It's much easier to hire a new guy and let him play with the db rather than explaining all the littles joins one at a time.
Thanks Ninja,
I will just like to trouble a little more, I hope you will bear me while I try and solve the problem.
"Like I said I NEVER leave the keys out of the dev phase. And then I'm good enough at tuning that I don't need to take 'em. So I'd start there." .
Do you mean that during your development process you always put constraints to ensure data integrity during development stages and Once it comes to tuning the database you decide whether to keep the constraint or remove it .
One more thing to consider is that those FKS are self documenting the DB for you. It's much easier to hire a new guy and let him play with the db rather than explaining all the littles joins one at a time.
I could not understand what you mean by the above statement.
Thanks
Zubair