February 14, 2007 at 10:01 am
Hi,
I am trying to tune the performance of the database. I have table with ID column which is referenced by 5 other tables. The ID column currently is of datatype of FLOAT, I want to change it to INT. For me to change the datatype of the ID column, I have to the change the datatype of dependent columns too.
Apart from saving the storage bytes from float to int, will there be any gain in the performance. The column has only integer values and the table has 12 million rows.
any suggestions/inputs if the change in the datatype will improve the performance.
Thanks
February 14, 2007 at 1:18 pm
- saving the storage from float to int will save you space in the parent table and in de child-tables !
- indexes based on int will be smaler so they will be faster.
- using the correct datatype will always be better !
1) because it suites your data
2) because your programmers will not tempt to use it otherwize.
3) because it will save you space and transformationoverhead
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply