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

SQL Anywhere 11.0.0 » UltraLite - .NET Programming » UltraLite .NET 2.0 API Reference » ULTableSchema class

 

GetOptimalIndex method

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

Syntax
Visual Basic

Public Function GetOptimalIndex( _
   ByVal columnID As Integer _
) As ULIndexSchema
C#

public ULIndexSchema GetOptimalIndex(
   int columnID
);
Parameters
  • 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.

Remarks

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

See also