Primary Indexe

Database
Enthusiast

Primary Indexe

There are three columns in a table col1, col2, col3.

col1 is 100% unique data but data is never used
col2 is 98% unique data used for where clause
col3 is 95% unique data used for join processing

On which column it is better to create primary index and secondary index?

why?

Thanks

KIRAN

1 REPLY
Enthusiast

Re: Primary Indexe

How does table access most freqently in JOIN or Standalone in a query