Re: Foreign key in Oracle Sql

DA Morgan wrote:

> But I'd love to have you prove me wrong so here's a basic question.
> How would you use a function based index to enhance the retrieval
> performance of records in a column where the only values are "Y" and
> "N" and why would a B*Tree, bitmap, reverse, descending, domain,
> cluster, and/or compressed index not work as well?

oh, it's just a newsgroup, why should anybody be required to take a test in order to participate? or for that matter, to reply to some of the profane people that threaten violence? (on the latter point, i'm not exactly referring to the quoted poster) - i think it's best to treat them like tail-gaters - ignore them unless they've gone far enough to report them to the authorities. or to show respect for an inanimate object like Oracle?

what i'd like to see is a dbms that has the smarts to compile such a 'table' without even asking me and bind my application to the result without my help.

pc Received on Fri Jan 21 2005 - 19:07:21 CST