Using directive 'AVOID_INDEX' in a query did not work.

Technote (troubleshooting)


Problem(Abstract)

I am using AVOID_INDEX directive in a query. Why the query is using the INDEX PATH?

Cause

Because of the white space between the curly braces around the avoid_index directive

Example: Incorrect usage:

SELECT { + avoid_index (emp idx_dept_no)} ...

where 'emp' is a table name, which has an indexes called 'ids_dept_no', defined on one of it's column.

Resolving the problem

Remove the white space between the curly braces.


Example: Correct usage:

SELECT {+avoid_index(emp idx_dept_no)} ...

where 'emp' is a table name, which has an indexes called 'ids_dept_no', defined on one of it's column.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Servers

Software version:

10.0, 11.1, 11.5, 11.7, 12.1

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1623154

Modified date:

2013-04-15

Translate my page

Machine Translation

Content navigation