Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » UltraLite - .NET Programming » UltraLite .NET 2.0 API reference » ULTableSchema class


GetOptimalIndex method

The optimal index for searching a table using the specified column.

Visual Basic
Public Function GetOptimalIndex( _
   ByVal columnID As Integer _
) As ULIndexSchema
public ULIndexSchema GetOptimalIndex(
   int columnID
  • columnID   The ID number of the column. The value must be in the range [0,ULCursorSchema.ColumnCount>-1]. The first column in the table has an ID value of zero.

Return value

A ULIndexSchema object representing the optimal index for the specified column.


The specified column is the first column in the index, but the index may have more than one column.

See also