Hello community, I have one question.
We have one node type that have more than 5 million nodes per month. To cover license, we have to offer our customers ability to browse last six month. Also, we have to be able to give them last twelve month on request. Since those data is updated constantly, we have 3 index on it (minimum we were able to reduce "indexes will fix speed").
Now, let's say like this, node name is "CustomerStats". Now, we would like to keep all data in store (and older than twelve month). So we decide to create another node, "CustomerStatsArchive" and put single index on it (only on creation time).
My question is, if I do something like this
MATCH (s:CustomerStats) WHERE $from <= s.createdAt <= $to SET s:CustomerStatsArchive REMOVE s:CustomerStats
all indexes will be removed or they stay even if I change label (remove it from node)?