You are looking at the data in your table, most of the queries are ranges queries but every now and then a query gets executed for exactly one row. How would you index this? This is a very tough decision, right? You have 2 types of indexes to choose from, and if the index is a composite (multi column) index then you also have to worry about which column to place first so that you get a lean mean index seek.
With Sybase IQ you have these indexes to choose from
The Default column index
The Low_Fast (LF) index type
The High_Group (HG) index type
The High_Non_Group (HNG) index type
The Compare (CMP) index type
The Containment (WD) index type
The Date (DATE) index type
The Time (TIME) index type
The Datetime (DTTM) index type
The JOIN Index (Linear joins and Star joins)
Yes, a lot more than two, Sybase IQ does not have clustered or non clustered indexes. You can specify clustered index but it will be ignored.
What do you think? Do we need more indexes in SQL Server? What about BitMap indexes?