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

Posted in 2006

Art S. Kagel — Wed, 11 Jan 2006 21:28:03 -0500 — source: Usenet: comp.databases.informix

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