Multiple NUSI Access
Database designers frequently define multiple NUSIs on a table. Whether the Optimizer chooses to include one, all, or none of them in its query plan depends entirely on their individual and composite selectivity.
Database designers frequently define multiple NUSIs on a table. Whether the Optimizer chooses to include one, all, or none of them in its query plan depends entirely on their individual and composite selectivity.