(Jag Singh) In the absence of other advanced techniques for star join optimization, nested fact join with dimensions ensuring indexes are used for each dimension join delivers reasonable performance.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help