Add support for Co-existence of with "nodes" clause and shard affinity

Currently, when shard affinity is enabled, with "nodes" clause is not supported while creating indexes. This is a widely used clause by customers as they can control the index placement based on their requirement. 

When shard affinity is enabled, with "nodes" clause can not be supported as the nodes defined in with "nodes" clause may not share a common slot.  A new slot may have to be created to accommodate the index to support the with "nodes" clause. Creating new slots means more shards and this can lead to performance regressions.

The goal of this improvement is to investigate the potential performance regressions that can happen when with "nodes" clause is supported with shard affinity. If the performance regressions are not severe/minimal, then both with nodes clause and shard affinity can be supported by default