Explain what index types are supported by your local DBMS. Give the commands used to create each type.

What will be an ideal response?

Sybase supports B trees with the command:

```
create [unique] [clustered | nonclustered] index index_name
on table_name
(column_name [asc | desc] [, column_name [asc | desc]]...)
[with [fillfactor = pct | max_rows_per_page=num_rows ] ]
```

The unique option indicates that the search key is a key of the table (and hence duplicate values of the search key are not allowed). The asc | desc option speci?es whether index entries on the associated column are to be sorted in ascending or descending order. Either a ?ll factor or (not both) the maximum number of rows per page can be speci?ed. These constraints limit the number of rows on data pages or the number of index entries on the leaf pages of an unclustered index. The ?ll factor speci?es the initial percentage of the page that will be ?lled. However, the actual
percentage will change as the data changes. A speci?cation of the maximum number of rows per page, however, is maintained as the data changes.