Technote (FAQ)
This document applies only to the following language version(s):
English
Question
Comparing functional indexes with non-functional indexes
Answer
Same portion:
1.Index options like UNIQUE and CLUSTER, and access methods like B-Tree, R-Tree and user-defined access methods can apply to both functional and non-functional indexes.
2.Both types of indexes can specify a FILLFACTOR and both can specify storage options that control where the index is created and whether or not it is fragmented.
3.The oncheck utility can be used to validate and repair both functional and non-functional indexes
Different portion:
1.One main difference between functional and non-functional indexes is how they are handled during the CREATE and DROP operations.Functional didn't support ONLINE keyword,which means that an exclusive lock is always placed on the indexed table while a functional index is being created or dropped. All other users are prevented from accessing the table during this time.
functional index:
CREATE INDEX ... ONLINE; <== Not valid
DROP INDEX ... ONLINE; <== Not valid
Related information
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.