A table column in YSQL can have a default value. If an INSERT statement does not specify a value for the column, […]
Read More
Enforce 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 MorePitfalls of Adding a PK to an Existing Table in YSQL
Although it’s possible to add a primary key constraint to an existing table with the ALTER TABLE ADD CONSTRAINT command, it’s best […]
Read More