title: Unique vs non-unique index
body: <p>My table holds nearly 40+ million records., with DML. </p>
  
  <p>Would like to know  which one of these Unique or non-unique index would be better option for  implementation. To give better performance.</p>
  
  <p>Environment : Oracle 11g</p>