postgresql-index and optimization Introduction to indexing Index type B-tree index Hash index GiST index SP-GiST index GIN index BRIN index Create index unique index multi-column index function index partial index covering index View index Maintain index Delete index Introduction to indexing Index (Index) can be used to improve the query performance of the database; however, […]
Tag: indexing
Mysql indexing and query optimization
1 Index 1.1 What is an index An index is a data structure used in a database to speed up data retrieval. It is similar to a library catalog and can quickly find corresponding records based on keywords. In a database, an index consists of one or more columns, each of which stores the key […]
[Search engine] Document indexing and retrieval: Document indexing and retrieval
Author: Zen and the Art of Computer Programming 1. Introduction Search engines are one of the important ways to obtain Internet information. Whether used on PC, mobile or computer, you can quickly find the information you want. The construction of search engine indexes for document information is a more complex problem. The goal of Document […]
Handwritten database wheel project MYDB Part 5 | DataManager (DM) Data page indexing and upward management DataItem
This chapter introduces a simple page index and implements the DM layer’s abstraction of the upper layer: DataItem. 1. Page index Page index, which caches the free space of each page. It is used to quickly find a page with suitable space when the upper module performs an insertion operation without checking the information of […]
MySQL (2) indexing principle and optimization
MySQL series articles MySQL (1) basic architecture, SQL statement operation, try MySQL (2) indexing principle and optimization MySQL (3) SQL optimization, Buffer pool, Change buffer MySQL (4) transaction principle and analysis MySQL (5) caching strategy MySQL (6) master-slave replication Three paradigms of database Article directory MySQL Series Articles foreword 1. Index primary key index unique […]
Software Architecture – KWIC Indexing System
Introduction KWIC, as a question raised in ACM’s Paper in the early years, has been regarded as a classic of classroom lectures or homework by software design courses in universities all over the world. (From Wiki, FYI, D. L. Parnas uses a KWIC Index as an example on how to perform modular design in his […]
Transactions, Indexing, Rights Management and Backups
Transaction What is a transaction All or nothing SQL execution, A transfers money to B A: 800 B: 200 A-200->B SQL execution, B receives money from A A: 600 B: 400 Example above: If the execution of 1 is successful and the execution of 2 fails, then A has less money and B has not […]
Efficient Use and Exploration of .NET Indexing and Search Engines Powered by Lucene.Net: Examine’s Simple Application of Indexing and Searching Data and Its Scalability Analysis
Effective use and exploration of .NET index and search engine supported by Lucene.Net: Examine’s simple index and search data application and its scalability analysis Searching and indexing data is becoming increasingly important in the current technological environment, especially when dealing with large amounts of data. This makes us need a tool that can index and […]
MySQL indexing and optimization
MySQL index database index data structure binary tree red black tree B-tree B+ tree index hash index Clustered and nonclustered indexes secondary index covering index index pushdown Single column and combined index leftmost matching principle Mysql optimization index optimization sql optimization Database index Divided by data structure: B + tree, hash, full-text Divided by data […]
“View Optimization, Indexing Strategies, and Data Import and Export Skills”
Table of Contents 1. View explanation and analysis of advantages and disadvantages 1.1. What is a view? 1.2. What is the difference between a view and a data table? 1.3. Advantages of views 1.4. View Syntax 2. Index 2.1. What is an index 2.2. Why use indexes 2.3. Advantages and disadvantages 2.4. When not to […]