Hi, 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. Thanks in advance, Filip. -- *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* * System Engineer, Verzekeringen NV * * www.verzekeringen.be * * Oostkaai 23 B-2170 Merksem * * 03/6416673 - 0477/340942 * *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
