Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in database-indexes

How do I find a list of indexes on a temporary table that I've created in SQL Server 2012

EXPLAIN SELECT shows that MySQL is not using my index

How effective is creating index on column having two types of values only

PostgreSQL citext index vs lower expression index performance

multiple unique keys in nhibernate

Does a database column that has numbers need to be indexed?

Why is only reading faster in an indexed table and not writing?

What data type and index to use for a searchable userName column in a MySQL database?

Postgres. Can I expect a good speedup by switching BIGINT to INT

Why are these SQL Server statistics outdated, when it's set to auto-update?

Does SQL Server support hash indexes?

Can't create an index on a jsonb field with date

Neo4j: Step by Step to create an automatic index

Creating case-insensitive indexes on Postgres string array

Are UNIQUE SQL indexes also used for speeding up searches?

Is a single-column index needed when having multicolumn index?

mysql database-indexes

Determine status of an index in mysql

Different types of database indexes?

database database-indexes

How to get the list of column names for all indexes on a table in PostgreSQL?