Hi @nithish reddy minupuri , thanks for replying back.
<Writing it as another answer as word limit is crossing 1600 characters>
Id is unique identifier which is assigned to every item in Azure Cosmos DB while these items are created. Index concept is similar to what we have on other databases .Indexes are created by default in Cosmos DB on every property and they help us in writing the efficient and less expensive queries. This means if we exclude any property from index then the same query could take more RUs or more time to execute compared to the indexed properties which would then add to the cost. Now we might not notice any change for few documents but when the documents go to millions or more this would significantly impact the cost.
For retrieving all the properties lets take below examples:
Here we are adding 2 vertex:
g.addV('person').property('id', 'mary').property('firstName', 'Mary').property('lastName', 'Andersen').property('age', 39).property('pk', 'pk')
g.addV('person').property('id', 'steve').property('firstName', 'Steve').property('lastName', 'Wood').property('age', 40).property('pk', 'pk')
So if we run below query we will get both these with all the properties:
g.V().hasLabel('person').has('age', gt(38))
Result:
Same way we can write more queries depending upon the structure of our document.
Please let me know if this helps or we can discuss further on the same.
----------
Please don't forgot to click on accept it as answer button wherever the information provided helps you. This can be beneficial to other community members as well..