Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in database-indexes

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

Do i have to create a certain nonclustered index every now and then?

MySQL: Create a Foreign key without an Index

Different types of database indexes?

database database-indexes

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