Performance Issues

John Menke schrieb:

I am in the design phase of a new database that contains one very long
thin table. Are there any peformance issues with index lookups to a
table like this if table becomes extremly long? Lets say hundreds of
thousands to millions of records... Remember, the table only has one
column.

Another question. If the size of data in this record were to vary
greatly, would that have an impact on performance?

insert and updates times may grow linear if you've indices,
otherwise selects will be pretty stable.

Marten