Speeding up query

Read this

Share your PROFILE output.

Do you have an index/constraint on :keyWord(kwValue) ? and one on: :Product(seriesCode)

  • Remove the using scan
  • Add directions to your relationships.
  • remove the withs
  • use parameters