Hi, Sorry for just another question ...
I got another question regarding Trafodion indexes. Which type of index do you use? I conducted a test with 50000 table rows and a varying frequency (number of different entries in the indexed column). This test has shown the best results (best benefit over not using an index) for frequencies 100 and 1000 (I've tested 1, 5, 50, 100, 1000, 10000 and 50000, the optimizer didn't use the index for 1 and 5). I thought that B-Trees work best with a frequency close to log(number of rows), but the results have been best close to sqrt(number of rows). Do you have an explanation for that? I didn't find any information on that in the docu/wiki or on Git. Best regards Layla Layla Martin HP DualStudy Hewlett-Packard GmbH Telefon +49 7031 4504682 [email protected]<mailto:[email protected]> Herrenberger Strasse 140| 71034 Böblingen| www.hp.com/de/dualstudy<http://www.hp.com/de/dualstudy> [Description: Description: http://intranet.hp.com/country/germany/live/PublishingImages/NeuesLogoSmall.png] Follow us on: [facebook] <https://www.facebook.com/DualStudy.hp> [twitter] <http://twitter.com/hpdualstudy> [youtube] <http://www.youtube.com/user/hpDualStudy> Geschäftsführer: Heiko Meyer (Vorsitzender), Thomas Bässler, Volkhard Bregulla, Michael Eberhardt, Jochen Erlach, Angelika Gifford, Ernst Reichart Vorsitzender des Aufsichtsrats: Jörg Menno Harms Sitz der Gesellschaft: Böblingen, Amtsgericht Stuttgart HRB 244081 WEEE-Reg.-Nr. DE 30409072
