12 Posts on 12c: CTAS with Statistics

When executing a CREATE TABLE AS SELECT statement, new statistics are generated for this new database object. Unlike other features in this series, this is default behavior: BIG WIN.

Create the table.
Look, we have some statistics!
and column statistics!
and histograms!

It's just that simple. 

Comments

Post a Comment

Popular posts from this blog

AWS Re:Invent 2024

 I have the privilege of attending AWS Re:Invent conference from 02-Dec to 06-Dec. Here's my planned schedule for the week.  Sunday, 01-Dec Depart MSP @ 6:45pm CST Arrive LAS @ 8:12pm PST Monday, 02-Dec Design Secure and resilient relational database architectures on AWS Observability-driven development AWS Fundamentals for the accidental SQL Server database administrator Unleashing AWS Agility with Terraform How to navigate your SQL Server Migration journey with AWS Deep Dive into Amazon DynamoDB using Design Puzzles Visionaries in the Stadium w/ Angela Duckworth and some AI folks Tuesday, 03-Dec Identify and manage Amazon Aurora & RDS Snapshots Scalable database solutions with Aurora PostgreSQL Limitless Database Data models for Amazon Neptune using GenAI and diagram-as-code tools Deep Dive into Amazon Aurora query plan management Bingo Night Hashicorp Customer Reception @ Chica Wednesday, 04-Dec AWS Re:Invent 5k Race Essentials for migrating from Oracle to Amazon Aurora...
Read more

The Royals

 Not the ones from the MLB's American League Central Division, but the Royal Family .  I've said it before and I'll say it again: the royals don't occupy my brain space...at all. So I'm keen to ignore the current "crisis" of one particular Princess of Wales. There are actual crises in Israel, Ukraine, and Senegal. Move along. 
Read more