|
||||||
If no match is found, the index number used is <the largest data file index-number> + 1.
An index in X$Index without a matching key in the data file is referred to as a phantom index and is not used by the database engine.
|
||||||
When successful, an index with the specified index-number is added to both the data file and X$Index.
|
||||||
When successful, an index with the specified index-number is added to X$Index only. Nothing is inserted into the data file.
If the specified index-number exists in the data file and not in X$Index, and the column and index attributes match the index to be added, the index with the specified index-number is added to X$Index. Otherwise, an error is returned.
|
1193
|
|||
n/a1
|
1193
|
||
n/a1
|
n/a1
|
1193
|
|
1”n/a” stands for “not applicable”
2”rounded up” means that the page size is rounded up to the next size supported by the file version. For example, 512 is rounded up to 1,024, 2,560 is rounded up to 4,096, and so forth.
3The maximum number of index segments that can be used with the relational interface is 119. For the transactional interface, the maximum number is 204 for a page size of 4,096, and 420 for page sizes 8,192 and 16,384.
|