When should I create a new index?
761806Mar 22 2010 — edited Mar 23 2010Hi All, I've got a table with ~62K rows. The PK is case_id. Would it be worth creating an index on the case_id w/ that number of rows in a table? The sql statement does pop up occasionally on my OEM "Top SQL Statements". Is there a rule of thumb when calculating whether an index would benefit a table? For instance, if the table is really tiny, like 500 rows, is it even worth creating an index? If small tables really don't warrant indexes, what size is considered small? If a table has less than 10,000 rows would it be considered small? 100,000? Thanks for any help! I'm learning the ropes w/ Oracle and have all these questions that most of the general Oracle articles don't answer. Cheers!