I am downloading a bulk of stock data:
Ticker symbol, company name, industry sector,
Open, high, low, close
I was wondering performance-wise if separating the ticker, company name, industry sector from the price data would be optimal, as the tickersymbol and companyname just repeat over and over again.
Or would inner joining the ticker+price every time be slower?
- single table (ticker/price), or
- two tables (ticker)(price)?