Re: Foreign key in Oracle Sql
Date: Fri, 21 Jan 2005 18:55:19 -0800
Message-ID: <41f1c08b$1_1_at_127.0.0.1>
pc 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?
Wouldn't it have just been easier and had more integrity to admit you don't know the answer?
> 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
This is a clear demonstration that you have at most a cursory knowledge of databases and even that is generous on my part. How could a table, in advance, know the cardinality of the data that will be loaded into it? Perhaps a crystal ball? Or how about data skew? A built in Ouija board function? Or the percentage of each block/page would need to be kept empty to handle updates without chaining? Taro cards?
Some day you'll get exactly what you want. No doubt Microsoft will sell it to the same people that currently think MS Access is a database. And it will perform as abysmally as all similar products do and be relegated to being the butt of jokes.
I rarely give this type of advice but:
The first rule of holes: If you are in one stop digging.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Sat Jan 22 2005 - 03:55:19 CET