![]() The number of distinct property values is MATCH (n:Node) RETURN count(DISTINCT n.foo). Number of distinct property values existing for the affected property keys divided by size.įor example, with an index CREATE INDEX FOR (n:Node) ON (n.foo), Number of entities affected by the index. ![]() (matches the output of SHOW INDEX YIELD populationPercent). The percentage of affected entities that were scanned by the index (matches the output of SHOW INDEX YIELD failureMessage). In case of index with status "FAILED" returns the failure message of a failed index (config MAP) - returns all indexes and constraints information for all NODE labels in the database.Indexes can have one of the following values: ONLINE, POPULATING and FAILED.Ĭonstraints have an empty string as a value The property keys that are affected by the index/constraint The label (or list of labels) of the index/constraint It is possible to define a set of relationship types to include or exclude in the config parameters. ![]() It is possible to define a set of labels to include or exclude in the config parameters.Ī(config MAP) - returns the indexes and constraints information for all the relationship types in the database. Non-constraint indexes can define compound indexes with label: pairings.Ī(config MAP) - returns all indexes and constraints information for all NODE labels in the database. To drop, create, or show indexes and constraints, you can use the following procedure: Qualified NameĪ(, dropExisting : true) yield label, key, keys, unique, action - drops all other existing indexes and constraints when dropExisting is true (default is true), and asserts that at the end of the operation the given indexes and unique constraints are there, each label:key pair is considered one constraint/label.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |