Hi,
I have a doubt related to non unique index. Unique and non unique index are used B tree architecture.But I want to know if I create non unique index on a column which has unique data.
when I query that table using that column ,it scans every leaf or when found that value it stops scan and give us result???