Faster queries with ZERO code changes!
Vložit
- čas přidán 8. 09. 2024
- Typically the performance of just a few critical queries is the one thing that will make (or break) the reputation of your application. You can use data clustering to make sure those critical queries always run fast.
Follow me!
blog: connor-mcdonal...
twitter: / connor_mc_d
The Podcast!
podcasts.apple...
open.spotify.c...
Subscribe for new tech videos every week
Other social media channels here: linktr.ee/connor
Music: The Wine, The Cars, Ah! Montmartre! - Late Night Feeler
Image credit: commons.wikime..., Igor Chuxlancev
#sql #database
You're a savior man! Thanks 🙏🙏🙏
Happy to help!
What happens to the new rows that are inserted? Will they be placed in the right place? Or is clustering an one time activity only? And that's the difference between clustering and partitioning?
direct mode operations observe the clusteing (ctas, insert-append, alter table move )
We just moved from 11 to 19. Some organizations only move when they have to. This is certainly one option I am going to try out very soon. Thanks!
Fantastic! Thanks Connor.
Can this be combined with partitioning on some other key, say order date (year)?
Maby not relevant for the case of an order table but for other cases.
Don't this so, You can arrange the data physically in only one way.
Thank you, Connor, for sharing knowledges :) !
wow, what a way to optimize the physical reads
Can I have similiar results by exporting a table and then importing it back with an "order by" clause?
not sure what import option you are referring to. A CTAS with an ORDER BY would do it
@@DatabaseDude Thanks! That's what I had in mind.
I meant "export with order by and then import" :)
This is so good and also reduced my burden.
How to get the Statistics of a query? I can't get that.
set autotrace on stat
@@DatabaseDude Thank you very much...!!!