Do I need to add an index on a table with one row?

Posted by briddums on Programmers See other posts from Programmers or by briddums
Published on 2012-06-04T17:27:25Z Indexed on 2012/06/04 22:46 UTC
Read the original article Hit count: 149

Filed under:

I'm creating a parameter table in our database. This table will have 1 row with values that are environment specific (production, development, etc).

Is there any reason why I should define an index on this table?

Update
This table is a parameter table which will be used to drive our job queue system. The table will be defined like this:

QueuePrm
  LogLvl    integer
  ShowMs    boolean
  Restart   boolean

This table will only ever have 1 row. No other table in our system will reference it.

© Programmers or respective owner

Related posts about database-design