Re: Re - new datablade announced for informix

Posted in 2004

Obnoxio The Clown — Wed, 23 Jun 2004 14:43:09 +0100 (BST) — source: Usenet: comp.databases.informix

rkusenet said: > > "Paul Watson" <paul@oninit.com> wrote in message > news:40D92FBD.B2B7A62A@oninit.com... >> AFAIK it does work with Oracle or at least can. With Informix >> we've seen 75% reduction in load times when compared with std b-tree >> indexes. > > how does the optimizer know how to use this index and not std B-tree > index. Because you can tell the optimiser about new indexing technologies and how efficient they are. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco http://www.catb.org/~esr/faqs/smart-questions.html sending to informix-list