Hi, I'm trying to get familiar with OrientDB's indexing to make some performance tests. I'm running a query on a class which uses 10+ conditions in the WHERE statement with range selections, constants and IN conditions. I've created the compound index in the same order as the fields appear in the WHERE statement but it seems like the index is ignored. The EXPLAIN command shows that the index is used, but the scanned documents number is the same as the number of documents in the class. After some experimentation I came to the conclusion that with 2 conditions the index is "working", so just part of the class is scanned, but after adding the third condition the whole class is scanned. I'm just not sure wether this is normal behaviour or not. Am I missing something?
Best regards, Mate -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.