
When to use index on properties?
I have an action in which a flow is created if it doesn't yet exists. The flow itself has a startdate, enddate and a relation. I determine the object on these properties. My log told me to index the dates because i use them for searching. But i was wondering, what does the creation of the index cost me vs the cost of not having it. Example: I have 1000 records that will be checked. 500 of them create a flow, the others were found. Is creating the index for these 500 faster than the 1000 lookups that i do without the index?
I have an action in which a flow is created if it doesn't yet exists. The flow itself has a startdate, enddate and a relation. I determine the object on these properties. My log told me to index the dates because i use them for searching. But i was wondering, what does the creation of the index cost me vs the cost of not having it. Example: I have 1000 records that will be checked. 500 of them create a flow, the others were found. Is creating the index for these 500 faster than the 1000 lookups that i do without the index?
Login to reply