Results 1 to 2 of 2

Thread: Create index

  1. #1
    Join Date
    Jan 2004
    Location
    Chicago
    Posts
    54

    Unanswered: Create index

    I created my index using this:

    CREATE INDEX index2 ON schma.table2 (...)

    The index was created. I cannot find it anywhere. Should it be in schma?

    Should the index be created like this (like DB2, Oracle)?

    CREATE INDEX schma.index2 ON schma.table2 (...)


    Thanks.

    Bruce

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Which engine are you using?

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Tags for this Thread

Posting Permissions

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