Hi,
I have written some procedures that I use quite a lot. After a recent update I started seeing a lot of VM stop-the-world pauses and everything went really slow.
I'm suspecting that I might have forgotten to create some index, but its quite a lot of work to go through the code in all the cases (which arent that many, but..)..
Is there any way to check if the "findNode" calls uses indexes? Something similar to PROFILE - run a query using my procedure and find out how stuff was found?
Im suspecing no, but...
