Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2004
    Posts
    24

    Unanswered: Create Index to a view

    hi,

    is it possible to create an index to a view?

    Our environment is a DB2 on AS/400 V5R3

    Thanks in advance.

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    index on view

    according the help this is not possible - doesn not seems logic either.
    why would you create an index just for one view
    if the index is on a table - all views can use it - because a query is always run against a table and not a view
    Best Regards, Guy Przytula

  3. #3
    Join Date
    Sep 2004
    Posts
    24
    the view contains an union statement...

    so i see no option to set an order by clause
    to the view... thats the reason for an index

    any idea to set an order by clause to a view?

  4. #4
    Join Date
    Nov 2004
    Posts
    374

    index on view

    select * from view order by xxx
    Guy Przytula

  5. #5
    Join Date
    Sep 2004
    Posts
    24
    select * from view order by xxx ... ;-))

    i need the order by statement at the creation of the view...

    the select... order by... "great idea" ...

    thanks for your help...

Posting Permissions

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