Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-13-2023 12:11 AM
Hi @Suteja Kanuri
I have tried the EXPLAIN command on several different query types.
Both with really simple queries and also more complex and restricted on other columns.
None of them apply the partitionfilter when only using the timestamp in the where clause.
If i use the partition-columns in the where-clause the the partitionfilters are enforced and the query goes a lot quicker. (Of course)
But it is paramount that this filtering works with the timestamp as well. All users using these table filter on the timestamp alone.