Please enable JavaScript.
Coggle requires JavaScript to display documents.
Indexes :card_index: - Coggle Diagram
Indexes :card_index:
engine to perform fast, not simply scanning though the entire table
Types
R-tress
(Spatial)
only with partial types, such geometry
don't use **where**, such B-tress
- MySQL GIS function
- RDMS
- PostgreSQL PostGIS
-
-
-
-
-
-
-
Multicolumn
-
CREATE TABLE test ( id INT NOT NULL, last_name CHAR(30) NOT NULL, first_name CHAR(30) NOT NULL, PRIMARY KEY (id), INDEX name (last_name,first_name));
Clustered
it's not index type,
it's a data store part
-
-
-