Hi, when joining a fact table with a large dimensi...
# questions-and-troubleshooting
a
Hi, when joining a fact table with a large dimension table, how can we avoid scanning the entire dimension if only a few rows match? Shouldn't the Prefix Index be used if the table is Primary Key?