Dontopedia

composite index

From Dontopedia, the open, paraconsistent wiki. (Last updated 2026-06-10.)

composite index has 16 facts recorded in Dontopedia across 2 references, with 4 live disagreements.

16 facts·11 predicates·2 sources·4 in dispute

Mostly:rdf:type(2), applied to(2), includes columns(2)

Maturity scale raw canonical shape-checked rule-derived certified

Inbound mentions (9)

Other subjects in dontopedia point AT this entity as a value. These are inverse relationships — e.g. "X motherOf this subject" — and answer questions the forward facts can't. Grouped by predicate.

hasIndexHas Index(2)

isIndexedByIs Indexed by(2)

containsRecommendationContains Recommendation(1)

createsIndexCreates Index(1)

implicatesIndexStructureImplicates Index Structure(1)

recommendsRecommends(1)

suggestsSuggests(1)

Other facts (14)

The long tail: predicates that appear too rarely to warrant their own section. Filter or scroll to find a specific one. Each row links to its source.

14 facts
PredicateValueRef
Rdf:typeIndex[1]
Rdf:typeIndex Type[2]
Applied toDocument Id Column[2]
Applied toOther Column[2]
Includes ColumnsDocument Id Column[2]
Includes ColumnsOther Column[2]
Applies to ColumnsModel Id and Version[1]
Has Descriptionincludes multiple columns[2]
PurposeMulti Column Query Optimization[2]
Sub Type ofIndex Type[2]
AchievesMulti Column Query Optimization[2]
Has NameIdx Composite[2]
OptimizesMulti Field Queries[2]
SupportsCombined Filtering[2]

Timeline

Timeline axis is valid_time — when each source says the fact was true in the world, not when Dontopedia learned about it. Retracted rows are kept for provenance; coloured stripes indicate the context kind.

typebeam/57f508a6-cf50-41ae-8787-39c9218ac525
ex:Index
labelbeam/57f508a6-cf50-41ae-8787-39c9218ac525
composite index
appliesToColumnsbeam/57f508a6-cf50-41ae-8787-39c9218ac525
ex:model_id-and-version
typebeam/92543d72-590a-4046-bfef-11efb61dbbf5
ex:IndexType
labelbeam/92543d72-590a-4046-bfef-11efb61dbbf5
Composite Index
hasDescriptionbeam/92543d72-590a-4046-bfef-11efb61dbbf5
includes multiple columns
appliedTobeam/92543d72-590a-4046-bfef-11efb61dbbf5
ex:document-id-column
appliedTobeam/92543d72-590a-4046-bfef-11efb61dbbf5
ex:other-column
purposebeam/92543d72-590a-4046-bfef-11efb61dbbf5
ex:multi-column-query-optimization
subTypeOfbeam/92543d72-590a-4046-bfef-11efb61dbbf5
ex:index-type
achievesbeam/92543d72-590a-4046-bfef-11efb61dbbf5
ex:multi-column-query-optimization
hasNamebeam/92543d72-590a-4046-bfef-11efb61dbbf5
ex:idx_composite
optimizesbeam/92543d72-590a-4046-bfef-11efb61dbbf5
ex:multi-field-queries
includesColumnsbeam/92543d72-590a-4046-bfef-11efb61dbbf5
ex:document-id-column
includesColumnsbeam/92543d72-590a-4046-bfef-11efb61dbbf5
ex:other-column
supportsbeam/92543d72-590a-4046-bfef-11efb61dbbf5
ex:combined-filtering

References (2)

2 references
  1. ctx:claims/beam/57f508a6-cf50-41ae-8787-39c9218ac525
  2. ctx:claims/beam/92543d72-590a-4046-bfef-11efb61dbbf5
    • full textbeam-chunk
      text/plain1 KBdoc:beam/92543d72-590a-4046-bfef-11efb61dbbf5
      Show excerpt
      CREATE INDEX idx_covering ON documents(document_id, title, content); ``` 3. **Primary Key or Unique Identifier**: Ensure that your table has a unique identifier, such as an auto-incrementing primary key, to uniquely identify each

See also

Keep researching

Missing something or suspicious of what's here? Kick off a research session — a Claude agent will investigate, cite its sources, and file new facts into a dedicated context you can review before accepting into the shared view.