Re: How to search date ranges

Michael Gill <mydba_at_usa.com> wrote in message news:<Xns91A3788CC9DC7mydba_at_142.165.21.10>...
> Ladies and Gentlemen (and geeks, too :-)

  If Oracle's marketing is to be believed, they have user-defined indexing.

  You might have a look at this:

    http://www.iiug.org/ver1/software/index_ORDBMS.html

   with particular reference to the Period BladeLet. It's a T-SQL implementation   that includes both a fast user-defined indexing approach and reasonably good   statistics to help with selectivity estimation. This works in INFORMIX's IDS   (and has for about four years). The documentation is here:

     http://www.iiug.org/members/memb_software/archive/period.html

   It was also written up in more detail in a recent book called "Open Source   Components for INFORMIX 9.X" or something like that. Amazon will know.

   If the Oracle marketing machine is to be believed version O8i has all of the   necessary interfaces and stuff to support this. You might like to try to   port it.

    Hope this helps. Let us know how you go.

          KR

                    Pb