I am curious why system fields like SCD is Current & SCD is TombStone are datatype bigint.
Is there a way to change them to tinyint? As far as I know they can only be 0 or 1.
Best answer by rory.smith
View originalWhy are history system fields BigInt?
Userlevel 3
+1
Userlevel 5
+7
Hi
I have suggested using a smaller int type to TimeXtender in the past; tinyint has the drawback that it does not support negative numbers making calculations based on that field a bit more tricky. It would be nice to have a choice to make it a bit smaller anyhow.
Userlevel 6
+5
Hi
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
