Hi,
I have some confusion around indices (full-text and index). Is it fine to
have same index for all full-text and non-full-text (or exact) fields? or
does it affect the performance? Or to put it in a different way, at what
point do we separate indices?
For example:
I have a NodeEntity 'Product' with exact and full text indices. I have added
all the fields to the same index.
public class Product {
@Indexed(indexName = "product-search", fulltext=true)
String name;
@Indexed(indexName = "product-search")
int expectedAmount;
@Indexed(indexName = "product-search", fulltext=true)
String details;
.....
}
I need to fire a compound query for fields name, details and expectedAmount.
Index<Node> namedProductIndex =
graphDatabaseContext.getIndex(Product.class, "product-search");
Iterable<Node> nodes = namedProductIndex.query("(name:*book* OR
details:*book*) AND expectedAmount:700");
Therefore, I added all the fields name, details and expectedAmount keys in
the same index called 'product-search'.
name and details are full text but expectedAmount is not required to be full
text. Is it ok to add full-text and non-full-ltext fields to the same index?
Many Thanks,
Sambodhi
_______________________________________________
Neo4j mailing list
[email protected]
https://lists.neo4j.org/mailman/listinfo/user
