what is recommended indexing rules for ETL in general?
404rajneesh4u
posted on 29 Apr 20Enjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds
The only objective of an Index is to reduce the amount of data scans during retrieval. With that said, Stage tables are primarily meant to stage the daily data and then eventually do CDC (Change data capture) with target tables. So, Use the columns that you will use to join the stage and target table to do the CDC Comparison. All the modern cloud data warehouse platforms support both numeric as well as character columns to be part of the index. So, Look at the join columns and then use your best judgement to choose the Index columns |
Post Comment