I want to build a table in SQL to store real-time variable changes. The table has only 3 columns: A Date/Time (Table Index), a variable ID and the Value. If this table can reach 10 million records, which option gives me the best performance in a SELECT (searching for a specific time interval and variable ID): A - A table with only 3 columns, with 10,000,000 records. B - A table with 6 columns, like: Date/Time1, ID1, Value1, Date/Time2, ID2, Value2, with 5,000,000 records. If I choose option B, I would perform a JOIN into the columns to obtain only 3 columns again (Date/Time, ID and Value). Thank you!