In YSQL, a view is the result set of a stored query, which can be queried in the same manner as a […]
Read More
Track 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 MoreLimit Access to Table Columns
In YugabyteDB’s YSQL api, securing columns from users or providing access to only a limited set of columns can be implemented via […]
Read MoreSet GUC Parameter Within the Scope of a Stored Procedure
PostgreSQL setting parameters are often called GUC, short for the name of the ‘Grand Unified Configuration scheme’ project that introduced them. Since […]
Read More