


We got a use case where we want to have composite primary key or a unique value for a combination fields of schema. We tried to add unique index using query service but failed to achieve. It will be very helpful if anyone assist me how to achieve.
Thanks in advance.
Views
Replies
Sign in to like this content
Total Likes
You might be unable to add a unique index using the query service because one possibility is that the fields you try to index are not unique. Another possibility is that the index you are trying to create is already present.
If you are not sure why you are not able to add a unique index, you can try the following:
If you are planning to create a unique index, you should carefully consider the following:
By carefully considering these factors, you can create unique indexes that will improve the performance of your queries and enforce your data integrity constraints.
Views
Replies
Sign in to like this content
Total Likes