Database Usage

• How Do I Change Distribution Columns?

• How Do I View and Set the Database Character Encoding?

• What Do I Do If Date Type Is Automatically Converted to the Timestamp Type During Table Creation?

• Do I Need to Run VACUUM FULL and ANALYZE on Common Tables Periodically?

• Do I Need to Set a Distribution Key After Setting a Primary Key?

• Is GaussDB(DWS) Compatible with PostgreSQL Stored Procedures?

• What Are Partitioned Tables, Partitions, and Partition Keys?

• How Can I Export the Table Structure?

• How Do I Delete Table Data Efficiently?

• How Do I View Foreign Table Information?

• If No Distribution Column Is Specified, How Will Data Be Stored?

• How Do I Replace the Null Result with 0?

• How Do I Check Whether a Table Is Row-Stored or Column-Stored?

• How Do I Query the Information About GaussDB(DWS) Column-Store Tables?

• Why Sometimes the GaussDB(DWS) Query Indexes Become Invalid?

• How Do I Use a User-Defined Function to Rewrite the CRC32() Function?

• What Are the Schemas Starting with pg_toast_temp* or pg_temp*?

• Solutions to Inconsistent GaussDB(DWS) Query Results

• Which System Catalogs That the VACUUM FULL Operation Cannot Be Performed on?

• In Which Scenarios Would a Statement Be "idle in transaction"?

• How Does GaussDB(DWS) Implement Row-to-Column and Column-to-Row Conversion?

• What Are the Differences Between Unique Constraints and Unique Indexes?

• What Are the Differences Between Functions and Stored Procedures?

• How Do I Delete Duplicate Table Data?

last updated: 2024-09-20 15:40 UTC - commit: 5fd4dba0b566a36499ac3e8f59d7bd0c645ba5f1