Welcome to the new Gigaspaces XAP forum. To recover your account, please follow these instructions.

Ask Your Question
0

Compound space index usage

Say I have the following compound space index:

@CompoundSpaceIndex(paths = {"A", "B", "C"})

If my query only includes "A" and "B" as qualifiers, do I still get the benefit of using that compound index?

If my query only includes "B" and "C" as qualifiers, do I get any benefit in that case?

Does order of qualifiers in a query make any difference as far as index utilization?

TIA.

asked 2015-09-10 12:40:35 -0600

Steve McCarthy gravatar image
edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0
  • Its currently not supported. All segments have to be included within the query to allow the compound index to be used. You will need another compound index to be defined if your query includes "A" and "C".- Order does not make a difference.-------- Original message --------From: forum@ask.gigaspaces.org

answered 2015-09-12 11:40:02 -0600

shay hassidim gravatar image
edit flag offensive delete link more

Comments

Ahh, I see. That behavior is different than most RDBMS where using the frst parts of a compound/composite index will still give you benefits.

Steve McCarthy gravatar imageSteve McCarthy ( 2015-09-15 13:22:59 -0600 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower

Stats

Asked: 2015-09-10 12:40:35 -0600

Seen: 1,736 times

Last updated: Sep 12 '15