Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    63

    Wink Unanswered: Create Index on view base on left outer join .

    Hi ,
    I am trying to Create Index on view but I can not due to the fact that this view is base on left outer join ( between 5 tables).
    It is very important to create the index because the current view performance must improve.

    Thanks,
    Eyal

  2. #2
    Join Date
    Jul 2003
    Posts
    55

    Re: Create Index on view base on left outer join .

    Simply, you cant.
    There are many requirements for the view to accept creating an index on it.

    The SELECT statement in the view cannot contain
    1. A derived table
    2. Rowset functions
    3. UNION operator
    4. Outer or self joins
    And many other things.



    Originally posted by eschapir
    Hi ,
    I am trying to Create Index on view but I can not due to the fact that this view is base on left outer join ( between 5 tables).
    It is very important to create the index because the current view performance must improve.

    Thanks,
    Eyal

Posting Permissions

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