We have partitioned one of our SQL Server tables on a Clustered Index
datetime column, we have a Primary key Non-clustered index column with Identity data type and this column is setup as a non-aligned index. There is one more column xyz which is
UniqueIdentifier datatype and xyz column also has Unique Non-clustered index.
The problem is most of our queries use the XYZ column to retrieve data as XYZ is guid and unique.
At this point we are not sure what will be the impact of setting XYZ column (
uniqueIdentifier) with an Aligned Index strategy vs Non-aligned Index strategy.