When to create indexes ?

To be created when table is queried for less than 2% or 4% to 25% of the table rows.