This is a dedicated watch page for a single video.
A delta table stores data for each ball bowled in a cricket match. Every time a ball is bowled, the name of the bowler, batter and the number of runs scored is added to the delta table manually as an INSERT statement. After storing data for 350 cricket matches, the data engineer noticed that the read queries are taking more time as compared to read queries on other tables of relatively same size. Which technique can be used by the data engineer to solve this problem in an efficient manner?