An Index that is a ‘subset’ of a pre-existing Index

(Hemant K Chitale) It is a common [mis]understanding that creating a new Index that is a subset of an existing Index is an unnecessary overhead. The argument goes "if you have an Index on (A,B,C) this Index can be used to satisfy queries where predicate ‘A’ is specified, so creating an additional In

Read More - Register for Free Membership