RE: question about index

From: <TESTAJ3_at_nationwide.com>
Date: Mon, 19 May 2008 14:40:49 -0400
Message-ID: <OF03DAE252.DF906507-ON8525744E.00668BC6-8525744E.00669CF1@lnotes-gw.ent.nwie.net>

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-l

Received on Mon May 19 2008 - 13:40:49 CDT