When querying a view, you can specify a text index on the underlying base table to improve response time. For example, suppose you create a text index on the Employees.Address column called EmployeeAddressTxtIdx. Then, you create a view on the Employees table called MyEmployeesView. Using a statement similar to the following, you can query the view using the text index on the underlying table.
SELECT COUNT(*) FROM MyEmployeesView WHERE CONTAINS( EmployeeAddressTxtIdx, 'Avenue' );
Searching a view using a text index on the underlying base table is restricted as follows:
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|