In Quick notes during a fiddle-session I played around with a table that contained all possible values for a date column. To fill it I used a FOR LOOP with an INSERT and a commit every 10000 records. That took 9:37 minutes for 3.652.061 records. That’s terrible performance and nothing that needs to be accepted … Fiddle riddle – Amazing: stuff gets faster and takes less space!
If you’re not living behind some red moon and you’re reading this blog, you will likely be aware that SAP HANA SPS 10 had just been released. With it also the SAP HANA Studio had been improved and extended. Since I personally like eye-candy and enjoy exploring new features when they come with a button … The 7th Niceness of new toys’n’tools