How do indexes actually work?
I watched the webinars about views and indexes and I have a few questions I hope someone will answer.
Are indices updated whenever new documents are posted, or are they only updated when the view is requested? (If they're updated incrementally whenever new documents are posted, why can a query specify that the index should be rebuilt?)
What is the likely performance of an index over a database with 10 million objects? Is the expected return time likely to be within seconds? minutes? hours?
Does adding each index impact performance of PUT operations in a significant way?
Thanks in advance!