Abstract
SQL Server supports mechanisms that allow you to store large amounts of unstructured text information. Since SQL Server 2008, one of those mechanisms has been the MAX lengthused with the variable-length character data types VARCHAR and NVARCHAR. This means you can store up to 2 GB worth of character information within a single column. While SQL Server can store this information, the 1,700-byte limit for nonclustered indexes and 900-byte limit on clustered indexes make indexing through traditional means a challenge. Fortunately, SQL Server offers another indexing mechanism for searching within these large data types, where full-text indexing comes into play.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2019 Jason Strate
About this chapter
Cite this chapter
Strate, J. (2019). Full-Text Indexing. In: Expert Performance Indexing in SQL Server 2019. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5464-6_7
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5464-6_7
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5463-9
Online ISBN: 978-1-4842-5464-6
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)