python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - composite-index

How to create Composite index in Hazelcast

I am trying to improve performance of Hazelcast lookup by using composite key. I have a class entity Class Entity { private Long id; private String field1; private String field2; priva...
test-img

Pratap

java

hazelcast

distributed-caching

hazelcast-imap

composite-index

Votes: 0

Answers: 2

Latest Answer

The only way I've found is IMap.getLocalMapStats().getIndexStats() as described here: https://docs.hazelcast.org/docs/3.12.1/manual/html-single/index.html#map-index-statistics
test-img

lpettinato

Does indexing on a part of a composite primary key is needed in Postgresql?

I have a (large) table with a composite primary key, composed of 5 columns (a, b, c, d, e). I'd like to efficiently select all rows having two of those columns (a + e) to a given value. In PostgreSQL,...
test-img

Laurent Grégoire

postgresql

indexing

primary-key

composite-primary-key

composite-index

Votes: 0

Answers: 1

Latest Answer

For best performance, you would need an additional index on (a, e). If that is an option, you can drop the primary key and replace it with one on (a, e, b, c, d). The primary key index would then supp...
test-img

Laurenz Albe

Posts

Questions

Blogs

Jobs