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.