They both are Single Component Index. Index Names are also same as field name. I have just created these indexes for my testing purpose. I have attached the df file also
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.