Re: Question about extensibility... creating your own index?

Michael Segel wrote: > Art S. Kagel wrote: > > >>Michael Segel wrote: >> >>>Ok, >>> >>>So is there any extensible gurus out there who can answer this one? >>> >>>Is it possible to create your own index scheme and also being able to >>>specify this as part of the SQL query? >>> >>>I think the best example would be if you wanted to create a UDT and then >>>index off of it. >>> >>>How much freedom does Informix give the developer of a UDR/UDT? >> >>Can be done. You can do the index a UDT using a UDR and a functional >>index if you want to use standard BTREE's or you can create your own index >>access methods as CopperEye did to create an index structure more >>efficient for your UDT. >> >>Art S. Kagel > > Thats cool. > > One idea would be to extend the BTREE, however, I think a complete rewrite > would be in order. > > Any pointers to any Redboook or which manual would have info on this? > (Yes, I actually do RTFM, but sometimes its a royal pain to try and find > the info in the PDF versions... ;-) > > I'm curious just how much freedom you have within a tablespace. > (And that's a loaded statement...) See: Virtual-Index Interface Programmer's Guide and the verable: User-Defined Routines and Data Types Developer's Guide > TIA! Anytime Mike. Art S. Kagel