> 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