Forum Discussion
Data types in Delta
Well, I did offer some advice as to why we still want to optimise data types. The engine will provide the resources necesarry to process data operations based on data types and precision. The bigger the data type and precision, the bigger the resources are used to process. If you keep your data type sizes to a minimum, this will help the engine only provision what it needs.
Also, if we define our tables with data type sizes in Delta, it will stick to the data type size (e.g. cannot declare a string as 100 and then insert 200 chars in)
Hi,
No, beside AndyDDC who shared the same question I had, I have not had any further information on the topic sadly.
Well, I did offer some advice as to why we still want to optimise data types. The engine will provide the resources necesarry to process data operations based on data types and precision. The bigger the data type and precision, the bigger the resources are used to process. If you keep your data type sizes to a minimum, this will help the engine only provision what it needs.
Also, if we define our tables with data type sizes in Delta, it will stick to the data type size (e.g. cannot declare a string as 100 and then insert 200 chars in)