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 MoreTurn on statement level timing in YCQL
You are probably familiar with the timing meta-command in YSQL which turns on and off displaying of how long each SQL statement […]
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