question about index
From: <TESTAJ3_at_nationwide.com>
Date: Mon, 19 May 2008 13:54:38 -0400
Message-ID: <OFB0541BF2.C853E9E4-ON8525744E.00618764-8525744E.006262B7@lnotes-gw.ent.nwie.net>
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 - 12:54:38 CDT
Date: Mon, 19 May 2008 13:54:38 -0400
Message-ID: <OFB0541BF2.C853E9E4-ON8525744E.00618764-8525744E.006262B7@lnotes-gw.ent.nwie.net>
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 - 12:54:38 CDT