question about index
- From: TESTAJ3@xxxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 19 May 2008 13:54:38 -0400
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:
