Tag:Partition table

  • Focus! Five key points of DWS development

    Time:2021-9-12

    Summary:Efficient use of database is a necessary skill for a qualified development engineer. How to use DWS for efficient development and improve application efficiency is the technical dry goods~~~ Efficient use of database is a necessary skill for a qualified development engineer. How to use DWS for efficient development and improve application efficiency, the following […]

  • (Oracle 11g) batch generation of move table and rebuild index statement

    Time:2021-8-31

    Some parameters of 12C version have changed. The move table supports online, but it has not been tried in production. –Batch generation of move table and rebuild index statement /*Replace the following attribute information, by xander.cui OWNER(SCHEMA NAME): A01_GOLDEN TABLE_NAME: ‘SFC_SN_TRAC_PART’ Tablespace: use the current tablespace (specify if you want to change) Parallel 4: enable […]

  • PostgreSQL partition table partition range

    Time:2021-8-18

    Conclusion: when creating a partition in a partition table, the range definition is closed on the left and open on the right. Create partition table create table orders ( id bigint, create_time timestamp(0) default current_timestamp ) partition by range (id); Create default partition When no child partition matches the inserted data, it is added to […]

  • Performance tuning of gaussdb (DWS) (3): definition of good taste table

    Time:2021-7-16

    abstractTable structure design is a key link of database modeling, and table definition directly determines the effective capacity of cluster and business query performance. This paper expounds some key factors that need to be paid attention to when defining tables in gaussdb (DWS) from the perspective of product architecture, function implementation and business characteristics. preface […]

  • Practice of Flink 1.11 and hive batch flow integrated data warehouse

    Time:2021-6-13

    Guide: Flink has provided the function of integrating with hive since 1.9.0. With the iteration of several versions, the function of integrating with hive has been further deepened in the latest Flink 1.11, and it has begun to try to integrate the streaming computing scene with hive. This paper mainly shares the new features of […]

  • MySQL partition table

    Time:2021-6-9

    MySQL partitioning is to decompose a table into several smaller tables. Logically, there is only one table or index, but physically, the table or index may consist of multiple physical partitions. Each partition is physically independent. Mysql database partition type: Range partition: row data is put into a partition based on column values belonging to […]

  • How to deal with high water mark in Oracle Database

    Time:2021-5-11

    1、 What is a high water mark? When Oracle database creates a table, it will allocate a segment for the table. For the convenience of understanding, the upper limit of the segment space to hold data is called high water mark (HWM). HWM is a mark to indicate how many unused blocks are allocated to […]

  • Exploration of MySQL partition table

    Time:2021-5-8

    background If you need to regularly clean up the historical data in an ordinary large table. You can use one or more delete statements with a where condition (where condition is time). If the amount of table data is large, it will cause great pressure on the database. Even if we delete the old data, […]

  • Get to the point! Five key points of DWS development

    Time:2021-4-6

    Abstract:Efficient use of database is a necessary skill for a qualified development engineer. How to use DWS for efficient development and improve application efficiency? Here comes the technology~~~ Efficient use of database is a qualified Development Engineer’s necessary skills, how to use DWS for efficient development, improve application efficiency, the following five points can guide […]

  • SQL server according to the partition table name to find the file and file group implementation script

    Time:2021-3-29

    SELECT ps.name AS PSName, dds.destination_idAS PartitionNumber, fg.name AS FileGroupName,fg.name, t.name, f.name as filename FROM (((sys.tables AS t INNER JOIN sys.indexes AS i ON (t.object_id = i.object_id)) INNER JOIN sys.partition_schemes AS ps ON (i.data_space_id = ps.data_space_id)) INNER JOIN sys.destination_data_spacesAS dds ON (ps.data_space_id = dds.partition_scheme_id)) INNER JOIN sys.filegroups AS fg ONdds.data_space_id =fg.data_space_id innerjoin sys.database_files f on f.data_space_id […]

  • Linux knowledge

    Time:2021-3-25

    Basics The five units of a computer include:input unit 、output unit 、control unit 、arithmetic logic unit 、Storage unitTop fivepart. The CPU occupies the control and arithmetic logic unit, and the storage unit contains memory and auxiliary memory; Unit of measurement Carry system Kilo Mega Giga Tera Peta Exa Zetta Binary 1024 1024K 1024M 1024G 1024T […]

  • MySQL learning notes (14): partition

    Time:2021-3-5

    This article is updated on June 30, 2019, using MySQL 5.7 and operating system deepin 15.4. catalog Partition type Range partition List partition Columns partition Hash partition Key partition Subarea Partition management Partition management of range partition and list partition Partition management of hash partition and key partition Partition type have access toSHOW PLUGINSCheck to […]