I have a table with 30 million rows.
One of the table's column is date column -- target_date not null. Non-unique Index has been created on this column.
Data was populated into this column using TRUNC(SYSDATE) function.
Daily volume of this table is around 50,000 rows.
USER_INDEXES Distinct_keys column's value is 605.
Index selectivity percentage is .002.
Can someone please advise if the index on this column is good to have or not. Thanks in advance.