Consider Two Unique Indexes for customer table.
Unique Index 1 :" Contact" (Single component Index - Only Contact field)
Unique Index 2: "Phone " (Single component Index - Only phone field)
Query:
for each customer where contact = "test" and phone = "23232323" no-lock:
end.
when I take "Xref" for the above query, the query is picking the "Phone" index. But as per alphabetical order, it should have picked up the Contact index.
Kindly provide suggestions for the above scenario.
Unique Index 1 :" Contact" (Single component Index - Only Contact field)
Unique Index 2: "Phone " (Single component Index - Only phone field)
Query:
for each customer where contact = "test" and phone = "23232323" no-lock:
end.
when I take "Xref" for the above query, the query is picking the "Phone" index. But as per alphabetical order, it should have picked up the Contact index.
Kindly provide suggestions for the above scenario.