May 14, 2009 at 7:08 am
PaulB (5/14/2009)
sabutp (5/14/2009)I am not sure in MS SQL but in Sysbase SQL separate indexes are created automatically for primary and foreign keys.
MS SQL Server != Sybase
They departed ways when SQL Server released version 4.2
In... what was that, 1995? I was working with both back then.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 14, 2009 at 7:31 am
Grant Fritchey (5/14/2009)In... what was that, 1995? I was working with both back then.
:w00t: So I'm not the only dinosaur around, huh? 😀
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 2 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply