One reason to set up full-text indexing in your database is to use ArcSDE XML columns such as with an ArcIMS Metadata Service. The database indexes and searches XML documents using its text indexing capabilities.
Beginning with 9.3, ArcSDE XML columns are supported in DB2 (except on z/OS), Informix, Oracle, PostgreSQL, and SQL Server. Each database requires text indexing functionality to be installed and configured to create an XML column.
In addition to enabling full text indexing, there are other DBTUNE configuration settings that need to be considered that will affect the language, storage, searching, and maintenance of an ArcSDE XML column. Definitions for these parameters can be found in the configuration parameter topics for each DBMS. Once an XML column has been created, many of its configuration settings can't be changed. Use the links below to learn about configuring a database to support text indexing and text searches.
If the XML column will store documents written in a language other than the default for your DBMS, both the database text indexing components and the DBTUNE settings must be properly configured for your language. The following information can be found in the DBMS-specific "Configuring <DBMS> database to support XML" topics.
