RE: question about index
- From: TESTAJ3@xxxxxxxxxxxxxx
- To: "Terrian, Thomas J Mr CTR DLA J6DIB" <Tom.Terrian.ctr@xxxxxxx>
- Date: Mon, 19 May 2008 14:40:49 -0400
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@xxxxxxx>
05/19/2008 02:39 PM
From
"Terrian, Thomas J Mr CTR DLA J6DIB" <Tom.Terrian.ctr@xxxxxxx>
To
<TESTAJ3@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
TESTAJ3@xxxxxxxxxxxxxx
Sent: Monday, May 19, 2008 1:55 PM
To: oracle-l@xxxxxxxxxxxxx
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.
Other related posts:
