When adding a conditional lookup in table A from table B an index is created in table B.
This is expected behaviour when the Index generation setting is set to “Automatic”.
However, if the lookup operator is set to “None”, no index is created in table B, eventhough index generation is set to automatic.
Additionally, if a lookup is at first created with operator “Max” (or any other) an index is created, but if the operator is later changed to “None” the index is automatically removed.
This seems like a bug. Is anyone else able to replicate this?
I have tested this on version 7026.1
