Any change in field data changes PK back to clustered


Author
Message
Charles R Hankey
Charles R Hankey
StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)
Group: Forum Members
Posts: 524, Visits: 30K
V 1.61.  PK is UID.  By default DDT created it clustered.  Change PK Index props to non-clustered in DDT

Later go back to this table in DDT  dirty buffer in any way ( on fields other than pk )

Save and close.  PK Index has changed back to clustered.  ( Can really bite you if you dont' remember to look for it )

Just something to look at before next release.  Smile 

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search