YugabyteDB stores YSQL system metadata, referred to as the YSQL system catalog, in special tables. The metadata includes information about tables, columns, […]
Read More
Move Data from One Table to Another Table in One Command
You can move data from one table to another in two SQL commands, an INSERT followed by a DELETE. But it’s possible […]
Read MoreAdd Columns to a View in YSQL
In YSQL, a view is the result set of a stored query, which can be queried in the same manner as a […]
Read MoreTrack User Defined Function Execution Counts and Runtimes
In YSQL we can track function call counts and time used by enabling the track_functions parameter. The default is none, but you can […]
Read MoreFaster Index Creation
We use the CREATE INDEX statement to create an index on the specified columns of the specified table. Indexes are primarily used […]
Read More