REPOST: Re: How to search date ranges
Date: 27 Jan 2002 14:23:02 -0800
Message-ID: <7$--$%%%_$$%%$%__$_at_news.noc.cabal.int>
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
- WAS CANCELLED BY =======: From: paul_geoffrey_brown_at_yahoo.com (Paul G. Brown) Control: cancel <57da7b56.0201271423.7b5ef5a1_at_posting.google.com> Subject: cmsg cancel <57da7b56.0201271423.7b5ef5a1_at_posting.google.com> Date: Sun, 27 Jan 2002 23:13:27 GMT Message-ID: <cancel.57da7b56.0201271423.7b5ef5a1_at_posting.google.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!fu-berlin.de!news.maxwell.syr.edu!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40719833
This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Sun Jan 27 2002 - 23:23:02 CET