Professional Web Applications Themes

AS400 Logical Files compared to CREATE VIEW - IBM DB2

I have two tables that have the same structure. For some purposes, I use a view which is defeined something like this: create view ALL_DATA as select * from CLIENT_1_DATA union all select * from CLIENT_2_DATA My question is: would it help performance on ANY types of queries to define a "Logical View" over the two underlying physical files and use that? What if I define a Logical View and specify a Key-sequence, would that help queries that use that sequence, or would a VIEW be just as good if the two underlying tables already have separate indexes (a.k.a. Logical ...

  1. #1

    Default AS400 Logical Files compared to CREATE VIEW

    I have two tables that have the same structure. For some purposes, I
    use a view which is defeined something like this:

    create view ALL_DATA
    as
    select * from CLIENT_1_DATA
    union all
    select * from CLIENT_2_DATA

    My question is: would it help performance on ANY types of queries to
    define a "Logical View" over the two underlying physical files and use
    that?
    What if I define a Logical View and specify a Key-sequence, would that
    help queries that use that sequence, or would a VIEW be just as good
    if the two underlying tables already have separate indexes (a.k.a.
    Logical Views) with the required sequence.

    thanks,

    - Darius
    Darius Guest

  2. #2

    Default Re: AS400 Logical Files compared to CREATE VIEW


    VIEW be just as good if the two underlying tables already have separate indexes
    (a.k.a. KEYED LOGICAL FILES) with the required sequence.
    --
    Kent Milligan, DB2 & BI team
    PartnerWorld for Developers, iSeries
    [email]kmillus.eye-bee-m.com[/email] (spam trick) GO HAWKEYES!!
    >>> [url]www.iseries.ibm.com/db2[/url]
    (opinions stated are not necessarily those of my employer)
    Kent Milligan Guest

Similar Threads

  1. How to create a forum thread view ?
    By Victor BX in forum Macromedia ColdFusion
    Replies: 4
    Last Post: May 19th, 02:36 PM
  2. Converting AS400 spool files to pdf using Acrobat 6.0
    By LuAnn_Trobec@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 0
    Last Post: April 28th, 02:49 PM
  3. Can I still create more logical partitions?
    By Johannes H. Ahlmann in forum Linux Setup, Configuration & Administration
    Replies: 1
    Last Post: July 30th, 05:07 AM
  4. Can't view filmstrip files
    By reggiefoto in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 1
    Last Post: June 27th, 07:39 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139