Virtual Computed Column Stats in CockroachDB tested
Sometimes it makes more sense to use a virtual column than a store column. For example, you may have a table with a gigantic amount of data, and the storage costs of adding a new store column could be prohibitively expensive. Whether a column is stored or virtual, column stats play a critical role in query optimization. They are what allow CockroachDB's cost-based optimizer to generate the most cost-efficient query plan.
In this video, Cockroach Labs Technical Evangelist Rob Reid demonstrates a Before and After scenario for enabling stats for virtual computed columns.
Virtual Computed Column Stats in CockroachDB tested
00:00 When should you use virtual computed columns in your database?
00:34 Creating a CockroachDB cluster, orders table, INDEX, and data
01:19 Testing without enabled stats collection
01:53 What happens when you enable stats collection?
02:22 How enabling stats collection can help the cost-based optimizer
Docs: Cost-based optimizer: https://www.cockroachlabs.com/docs/st...
Docs: Computed columns: https://www.cockroachlabs.com/docs/st...
#sql #softwarearchitecture #database
Смотрите видео Virtual Computed Column Stats in CockroachDB tested онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь CockroachDB 11 Июнь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 10 раз и оно понравилось людям.