All Questions
2 questions
0
votes
1
answer
125
views
Why Partition Scan is not happening
I have partitioned my table using day column defined as this in schema : day DATE
No i am running this query :
select * from my_table where day={d '2023-06-07'}
My Query Plan is showing me this :
...
- 539
0
votes
0
answers
740
views
SQL server table partitioning on current date
I have big table . This table has eventDate column . I need to partition this table on two parts . The first part will contain the records where (currentDate - 10 days > eventDate) and the second part ...
- 4,443