NO.INDEX

NO.INDEX

Top  Previous  Next

 

The NO.INDEX keyword causes the query processor to ignore any index that would otherwise be used to handle the selection clause of the query.

 

 

Format

 

NO.INDEX

 

 

Use of the NO.INDEX keyword may result in faster query processing where the selection clause includes a large proportion of the records in the file.