|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
This interface describes an index. It is used in the column SYS.SYSCONGLOMERATES.DESCRIPTOR and describes everything about an index except the index name and the table on which the index is defined. That information is available in the columns NAME and TABLEID of the table SYS.SYSCONGLOMERATES.
Method Summary | |
int[] |
baseColumnPositions()
Returns an array of column positions in the base table. |
int |
getKeyColumnPosition(int heapColumnPosition)
Returns the position of a column within the key (1-based). 0 means that the column is not in the key. |
java.lang.Integer |
getKeyColumnPosition(java.lang.Integer heapColumnPosition)
Returns the position of a column within the key (1-based). 0 means that the column is not in the key. |
java.lang.String |
indexType()
Returns the type of the index. |
boolean[] |
isAscending()
Returns array of boolean telling asc/desc info for each index key column for convenience of using together with baseColumnPositions method. |
boolean |
isAscending(java.lang.Integer keyColumnPosition)
Returns true if the specified column is ascending in the index (1-based). |
boolean |
isDescending(java.lang.Integer keyColumnPosition)
Returns true if the specified column is descending in the index (1-based). |
boolean |
isUnique()
Returns true if the index is unique. |
int |
numberOfOrderedColumns()
Returns the number of ordered columns. |
void |
setBaseColumnPositions(int[] baseColumnPositions)
set the baseColumnPositions field of the index descriptor. |
void |
setIsAscending(boolean[] isAscending)
set the isAscending field of the index descriptor. |
void |
setNumberOfOrderedColumns(int numberOfOrderedColumns)
set the numberOfOrderedColumns field of the index descriptor. |
Method Detail |
public boolean isUnique()
public int[] baseColumnPositions()
public java.lang.Integer getKeyColumnPosition(java.lang.Integer heapColumnPosition)
public int getKeyColumnPosition(int heapColumnPosition)
public int numberOfOrderedColumns()
public java.lang.String indexType()
public boolean[] isAscending()
public boolean isAscending(java.lang.Integer keyColumnPosition)
public boolean isDescending(java.lang.Integer keyColumnPosition)
public void setBaseColumnPositions(int[] baseColumnPositions)
public void setIsAscending(boolean[] isAscending)
public void setNumberOfOrderedColumns(int numberOfOrderedColumns)
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |