Re: question about index
Date: Tue, 20 May 2008 05:42:15 -0400
Message-ID: <OFD8A925CF.E2943920-ON8525744F.003545D1-8525744F.00354E64@lnotes-gw.ent.nwie.net>
your idea is probably the likely candidate, thanks everyone.
Joe
You can have it: Fast, Right or Cheap, pick 2 of the 3. Fast + Right is Expensive
Fast + Cheap will be incorrect.
Right + Cheap will take a while.
David Aldridge <david_at_david-aldridge.com>
Sent by: oracle-l-bounce_at_freelists.org
05/19/2008 04:49 PM
Please respond to david_at_david-aldridge.com
From
David Aldridge <david_at_david-aldridge.com>
To
TESTAJ3_at_nationwide.com, "Terrian, Thomas J Mr CTR DLA J6DIB"
<Tom.Terrian.ctr_at_dla.mil>
cc
oracle-l_at_freelists.org
Subject
Re: question about index
It's just an index built on the literal string 'X1' -- yes, very odd. Developer got wrong index-creation syntax and forgot to drop it afterwards?
- Original Message ---- From: "TESTAJ3_at_nationwide.com" <TESTAJ3_at_nationwide.com> To: "Terrian, Thomas J Mr CTR DLA J6DIB" <Tom.Terrian.ctr_at_dla.mil> Cc: oracle-l_at_freelists.org Sent: Monday, May 19, 2008 2:40:49 PM Subject: RE: question about index
thats what was confusing me, if it had a function involved, i'd understand but this just seems stupid to me :)
joe
You can have it: Fast, Right or Cheap, pick 2 of the 3. Fast + Right is Expensive
Fast + Cheap will be incorrect.
Right + Cheap will take a while.
"Terrian, Thomas J Mr CTR DLA J6DIB" <Tom.Terrian.ctr_at_dla.mil>
05/19/2008 02:39 PM
From
"Terrian, Thomas J Mr CTR DLA J6DIB" <Tom.Terrian.ctr_at_dla.mil>
To
<TESTAJ3_at_nationwide.com>, <oracle-l_at_freelists.org>
cc
Subject
RE: question about index
Function based index......but I am not sure how you would use it.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
TESTAJ3_at_nationwide.com
Sent: Monday, May 19, 2008 1:55 PM
To: oracle-l_at_freelists.org
Subject: question about index
Ok i guess i'm having a brain fart, someone asked me about this and for the life of me i can't figure it out. The 2nd index, what exactly is it doing with single quotes around the column name??
SQL> create table z1(x1 number, x2 date);
Table created.
SQL> CREATE INDEX X1 ON Z1 (X1); Index created.
SQL> CREATE INDEX X2 ON Z1 ('X1'); Index created.
Thanks, Joe
You can have it: Fast, Right or Cheap, pick 2 of the 3. Fast + Right is Expensive
Fast + Cheap will be incorrect.
Right + Cheap will take a while.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 20 2008 - 04:42:15 CDT