StackOverflow Questions for Tag: database-indexes

Ivan Virabyan

Reputation: 1694

Why would MySQL use index intersection instead of combined index?

mysqlquery-optimizationsql-execution-plandatabase-indexes

Score: 8

Answers: 3

Rodrigo

Reputation: 2503

Why does PostgreSQL not use the trigram index?

postgresqldatabase-indexestrigram

Score: 7

Answers: 1

Piyush Bali

Reputation: 125

Database native function while creating index with Liquibase

javapostgresqloracle-databaseliquibasedatabase-indexes

Score: 2

Answers: 1

giles3

Reputation: 487

Does MySQL (InnoDB) index null values in a composite index?

mysqldatabase-indexes

Score: 0

Answers: 1

Tommy Elliott

Reputation: 491

How can I quickly detect and resolve SQL Server Index fragmentation for a database?

sqlsql-serverazure-sql-databasedatabase-indexesfragmentation

Score: 13

Answers: 4

dbu

Reputation: 1562

Why is postgres not using my index on a json column?

jsonpostgresqldatabase-indexes

Score: 0

Answers: 1

Ryan Her

Reputation: 1117

Postgres not using index when index scan is much better option

sqlpostgresqlpostgresql-performancedatabase-indexes

Score: 42

Answers: 2

AntonioK

Reputation: 727

Reindex multiple indexes in postgresql in one query

postgresqldatabase-indexes

Score: 0

Answers: 1

Munib

Reputation: 3701

Do I need to add an Index on ORDER BY field?

mysqlsqldatabase-indexes

Score: 33

Answers: 8

user2607417

Reputation:

SQL Server 2008: How to count all indexes on all tables in Database?

sql-server-2008database-indexes

Score: 2

Answers: 2

Richard Wheeldon

Reputation: 1118

Create primary index for primary key in postgres with desc ordering

postgresqlcomposite-primary-keydatabase-indexes

Score: 0

Answers: 1

Morris de Oryx

Reputation: 2195

What Postgres 13 index types support distance searches?

postgresqldatabase-indexespg-catalog

Score: 2

Answers: 3

Roberto

Reputation: 41

How to add two index for the same column in DB with db_schema.xml

magento2database-indexes

Score: 0

Answers: 0

Julian

Reputation: 36800

Why do I get a Clustered Index Scan instead of a Table Scan?

sql-serversql-execution-plandatabase-indexes

Score: 0

Answers: 0

Finamore00

Reputation: 45

Why is PostgreSQL sorting a seemingly already sorted result set?

databasepostgresqlquery-optimizationrelational-databasedatabase-indexes

Score: 0

Answers: 1

133794m3r

Reputation: 5118

Using IndexedDB Like SQL. Query with multiple index values that are not in a range

javascriptindexeddbdatabase-indexes

Score: 0

Answers: 2

JaniH

Reputation: 59

querying sys.dm_db_index_physical_stats not working

azuret-sqlazure-synapsedatabase-indexes

Score: 1

Answers: 1

let_there_be_light

Reputation: 1007

Multiple indexes vs single index on multiple columns in postgresql

postgresqldatabase-indexes

Score: 65

Answers: 3

user24266786

Reputation: 11

Does the PolarDB engine selection of X-Engine not support columnar indexes?

database-indexespolardb

Score: 0

Answers: 0

Jawad Ali

Reputation: 71

AWS Amplify GraphQl multiple indexes on schema for separate queries

indexinggraphqlamazon-dynamodbaws-amplifydatabase-indexes

Score: 0

Answers: 0

PreviousPage 1Next