Here are 3 interesting (to me) numbers:
1. creating index on expression (func(timestamp)) takes 5 seconds
2. creating check constraint on the same expression takes 10 seconds
3. adding partition table based on the same expression without check expression
takes 20 seconds (this has been
Thank you! Thank you! Thank you!
I would not have figured it out, but solution is so simple.
Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10
From: David Rowley
Sent: Sunday, October 21, 2018 6:50:47 PM
To: Dinko Pa
I have created table partitioned by list on expression using timestamp column,
so for each timestamp value function returns int and each partition table is
for single value (range of timestamp for which function result is the same).
This helps me to simplify querying as I do not need to always