In the YBA Platform, only user-created YCQL keyspaces can currently be backed up and restored; system keyspaces and tables, including roles and […]
Read MoreBoost Performance by Splitting and Distributing Massive UPDATE Operations
The UPDATE statement modifies the values of specified columns in all rows that meet certain conditions. When no conditions are specified in […]
Read MoreChange the Owner of a View in YSQL
When a CREATE VIEW statement is issued in a session, the view’s ownership is assigned to the current session user. Example: yugabyte=# […]
Read MoreChange the Owner of a Sequence in YSQL
When you issue a CREATE SEQUENCE statement in a session, the current session user becomes the owner of the seqeunce. Example: yugabyte=# […]
Read MoreCheck for Invalid Indexes in YSQL
If an online CREATE INDEX command fails, an invalid index may be left behind. These indexes are not usable in queries, so […]
Read More