Questions about database-indexes
Read more about database-indexes
python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
How to efficiently index fields with an identical (and long) prefix in PostgreSQL?
I’m working with identifiers in a rather unusual format: every single ID has the same prefix and the prefix consists of as many as 25 characters. The only thing that is unique is the last part of the ...
Chris Kobrzak
Votes: 0
Answers: 1
Index and primary key in large table that doesn't have an Id column
I'm looking for guidance on the best practice for adding indexes / primary key for the following table in SQL Server.
My goal is to maximize performance mostly on selecting data, but also in inserts.
...
MikeO
Votes: 0
Answers: 0
MongoDB TTL index never deletes records
I created an index as shown below and added a createdAt field to each new record added to the db. The records should be auto-deleted after 24 hours however I have waited days and nothing has been dele...
Amber Johnson
Votes: 0
Answers: 1
Why do I get a different number of hits in a MySQL query if I use an index or not
I am new in MySQL and I do not understand, why if I use index on JSON column, result set is different as without index.
I have a simple table:
CREATE TABLE jsontest (
jsondata JSON
);
Table is filled...
rtmktl
Votes: 0
Answers: 1