Describe the term sparse filtered index

Describe the term sparse filtered index.

E

Expert

Verified

Filtered index:

Similarly there are several null value rows within sparse columns; they are suitable for filtered indexes. The filtered index upon a sparse column can accommodate only the rows / tuples that populate values. The index created along with filtered index is small and more proficient index.

   Related Questions in PL-SQL Programming

©TutorsGlobe All rights reserved 2022-2023.