Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Index question

Index question

From: Shaw, John B <jbshaw_at_ingr.com>
Date: Tue, 10 Oct 2000 13:16:34 -0500
Message-Id: <10645.118890@fatcity.com>


I ran sql analyze and it came back with a recommended index CREATE INDEX MAIN_ID

     ON MAIN
        (MAIN_ID,
         "LAST",
         FIRST)

    LOGGING
    INITRANS 2
    MAXTRANS 255
    TABLESPACE INDX
    PCTFREE 0
    STORAGE (
        INITIAL 128K
        NEXT 128K
        PCTINCREASE 0
        MINEXTENTS 1
        MAXEXTENTS 1024);

Why is the second column in quotes "LAST" - what does this do?

.... . .-.. .--. .. ...- . -... . . -. .--. .-. --- -... . -.. John B. Shaw
Intergraph Public Safety
mailstop LR24A4
jbshaw_at_ingr.com
256-730-8038
All the usual disclaimers and some of the certifications Received on Tue Oct 10 2000 - 13:16:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US