Materialized views in YSQL are relations that persist the results of a query. They can be created using the CREATE MATERIALIZED VIEW […]
Read More
Update Current Rows When Adding a Column with a Default
A table column in YSQL can have a default value. If an INSERT statement does not specify a value for the column, […]
Read MoreEnforce Uniqueness Across Partitions (Option 1)
Partitioning is another term for physically dividing large tables in YugabyteDB into smaller, more manageable tables to improve performance. Because partitioned tables […]
Read MoreCreate a Secondary Index on a Collection in YCQL
YCQL supports collection data types to specify columns for data objects that can contain more than one value. These include the following data […]
Read MoreGlobal Variables in YSQL
There are a lot of configuration parameters in YSQL that affect the behavior of the Yugabyte database system. The SHOW command in […]
Read More