October 15, 2013 at 4:59 am
From what i understand, inserted/deleted tables never inherit "real table's" PRIMARY KEY, does anyone knows how come?
It makes standard inserted/deleted-queries quite slow...
October 15, 2013 at 7:00 am
inserted and deleted are simply pseudo-tables materialised from the transaction log records. SQL doesn't look at the table they're based off (except for data types and column names), so they have no other structures 9pk, index, foreign key, etc)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 16, 2013 at 12:22 am
Oh ok, that clears things up. Thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply