Filip Sergeys wrote: > In a table with a few milion records there is 1 column with only a 100 > different values. I like to build an index on that column. In > oracle you > can choose a bitmap type of index that is optimized for such > situation. > Does sapdb have something similar? > > Secondly, how can i force a query to use a certain index a la style > "select /*+INDEX(table_name index_name)*/ from ..." like you > can use in > oracle. > I couldn't find any hints in the documentation that about this.
MAX DB doesn't support bitmap indexes and it's not on our todo list so far. With version 7.4 we introduce some optimizer hints in MAX DB more or less similar to oracle syntax. But there is no documentation on this topic because we only thought as a test feature of it. Best regards, Holger SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
