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?
thanks for any replys....