Top "Compound-index" questions

MySQL: make a compound index of 3 fields, or make 3 separate indices?

I have a MySQL table that has, among other attributes, a timestamp, a type and a user_id. All of …

Read More
mysql indexing compound-index
How does the order of compound indexes matter in MongoDB performance-wise?

We need to create a compound index in the same order as the parameters are being queried. Does this order …

Read More
mongodb indexing compound-index
MongoError: E11000 duplicate key error collection for unique compound index

Question is related to unique compound index unlike other such questions which have unique index only. I also have sparse: …

Read More
mongodb indexing compound-index
multiple constraint keys

if i have tabled: Resource (id (PK), name) Manager (id(PK), resource_id (FK), manager_resource_ID(FK)) Should resource_…

Read More
sql-server compound-index
creating a compound index in c#

I want to create a compound index where one key should be in ascending, the second key in descending order. …

Read More
c# .net mongodb mongodb-.net-driver compound-index