This forum is now a read-only archive. All commenting, posting, registration services have been turned off. Those needing community support and/or wanting to ask questions should refer to the Tag/Forum map, and to http://spring.io/questions for a curated list of stackoverflow tags that Pivotal engineers, and the community, monitor.

Need a good explanation of the different index types

Jul 17th, 2012, 09:48 PM

Sorry forgot to add, using SDN

So I am trying to write some queries based on properties that have indexes, and the results I expect are not the results I get, and I think it is because of the type of index that I am using. And in looking at IndexType I realized I didn't fully understand what they mean.

So is there a good place to find out exactly what FULLTEXT means and what SIMPLE, UNIQUE and POINT mean.

I expected FULLTEXT to mean if I had a String

"Hello World How Are You Doing"

I could search for "How" and that string would return. But I am not seeing that I have a property title in my event and one node with the value

"USC Game3 - Against Rival UCLA"

If I search for "USC*" I get that row, but if I search for "UCLA*" I do not. If I search for "Against" I do not get that row either. So I am thinking that what I am expecting is what you get with PLAIN index instead?

Comment

There is something in SDN that is making it not work correctly, because I can use the same query in the shell and it work, but in SDN code it doesn't work as advertising.

As far as the documentation for SDN goes, Michael knows that I feel that the docs are lacking in real explanations beyond the thin surface and it should be more detailed as at this time (and that we are working on that), that is the only source of documentation that is out there. So the docs don't explain how each index types works in SDN, even if delegating.