Re: question about index

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@xxxxxxxxxxxxxxxxxx>
 
Sent by: oracle-l-bounce@xxxxxxxxxxxxx




05/19/2008 04:49 PM
Please respond to david@xxxxxxxxxxxxxxxxxx

From
David Aldridge <david@xxxxxxxxxxxxxxxxxx>
To
TESTAJ3@xxxxxxxxxxxxxx, "Terrian, Thomas J Mr CTR DLA J6DIB" 
<Tom.Terrian.ctr@xxxxxxx>
cc
oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxx" <TESTAJ3@xxxxxxxxxxxxxx>
To: "Terrian, Thomas J Mr CTR DLA J6DIB" <Tom.Terrian.ctr@xxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx
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@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: