Oracle Index on table with 50 rows increase performance?
Posted on 2010-11-18
A table that looks like this with 50 records for each state:
Is there a performance gain adding an index to state_code column when executing the query like below?
select state_code_id from state_codes where state_code = 'FL';
The real questions is, in Oracle, is there a threshold where an index shouldn't be used if there # rows in the table are below a certain value? Is there any documentation for Oracle that discusses this?