Re: Foreign key in Oracle Sql
From: pc <toledobythesea_at_oohay.moc>
Date: Sat, 22 Jan 2005 01:07:21 GMT
Message-ID: <dHhId.16203$Qb.6561_at_edtnps89>
Date: Sat, 22 Jan 2005 01:07:21 GMT
Message-ID: <dHhId.16203$Qb.6561_at_edtnps89>
> 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?
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