DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: the structure of the table and index are

  1. #1
    Join Date
    Jul 2001
    Location
    Monterrey, N.L. Mexico
    Posts
    2

    Smile

    desc ausp
    Name Null? Type
    *MANDT NOT NULL VARCHAR2(3)
    *OBJEK NOT NULL VARCHAR2(50)
    *ATINN NOT NULL VARCHAR2(10)
    * ATZHL NOT NULL VARCHAR2(3)
    * MAFID NOT NULL VARCHAR2(1)
    *KLART NOT NULL VARCHAR2(3)
    ADZHL NOT NULL VARCHAR2(4)
    *ATWRT VARCHAR2(30)
    * ATFLV FLOAT(126)
    ATAWE VARCHAR2(3)
    ATFLB FLOAT(126)
    ATAW1 VARCHAR2(3)
    ATCOD NOT NULL VARCHAR2(1)
    ATTLV FLOAT(126)
    ATTLB FLOAT(126)
    ATPRZ VARCHAR2(1)
    ATINC FLOAT(126)
    ATAUT VARCHAR2(1)
    AENNR VARCHAR2(12)
    *DATUV NOT NULL VARCHAR2(8)
    LKENZ NOT NULL VARCHAR2(1)
    ATIMB VARCHAR2(10)
    ATZIS VARCHAR2(3)
    ATSRT NOT NULL VARCHAR2(4)
    ATVGLART NOT NULL VARCHAR2(1)

    * those fields compose the index

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    They are not null colums. So it doesn't mean they are indexed.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width