Table 3 The mainly coding examples for the methods of optimization.

Create an index labeled as Pavement

Create index on:Pavement ( )

Use index to query target data

Match (n:Pavement)

Using Index n:Pavement

Where n.PavementName = ' '

Create attribute unique constraints for the label which is PavementName

Constraint on

Create constraint on (p: Pavement)

Assert p.PavementName is unique

Delete the index

Drop index on:Pavement ( )

Delete the constraint

Drop constraint on ( )

assert p.PavementName is unique