Search the Community
Showing results for tags 'indexes'.
Types of Indexes: Full - examines all of the words in every stored document as it tries to match search criteria (text specified by a user). Partial - also known as filtered index is an index which has some condition applied to it so that it includes a subset of rows in the table. Partial-Blocked - ? Multi - ? Does anyone know any learning resources where I can read up on partial-blocked and multi indexes? I'm unable to find anything under these terms, perhaps they are known as something else? Also, how do these compare to types of index found here: http://en.wikipedia.org/wiki/Databa