Professional Web Applications Themes

Central Database Design - Microsoft SQL / MS SQL Server

Indexed views are only really good for aggregations and joining data from mutiple tables, is this what you need to do??? Several of our tables are over a million rows in our production environment and it all comes down to indexing. Did you create new indexes designed for queries or are they the existing indexes from the original tables? "Shamim" <com> wrote in message news:#phx.gbl... ...

  1. #1

    Default Re: Central Database Design

    Indexed views are only really good for aggregations and joining data from
    mutiple tables, is this what you need to do??? Several of our tables are
    over a million rows in our production environment and it all comes down to
    indexing. Did you create new indexes designed for queries or are they the
    existing indexes from the original tables?


    "Shamim" <com> wrote in message
    news:#phx.gbl... 


    Kevin Guest

  2. #2

    Default Re: Central Database Design

    I am sorry, I meant PARTITIONED VIEWS

    Sh

    "Kevin Brooks" <net> wrote in message
    news:phx.gbl... 
    >
    >[/ref]


    Shamim Guest

  3. #3

    Default Re: Central Database Design

    Partition views can help here. You will be able to keep table sizes down
    and this can increase query times when done right. It sounds like you moved
    multiple tables into one table. If this is the case you will need to break
    them back out into smaller tables, add partitioning columns, modify Primary
    Keys and build the view. That might be a hassle. I can query a 20million
    record table and get a response back in under a second, I just did a query
    on 250million and elasped time was 10sec(only one index on there, I know I
    could get quicker:)). Did you change indexes for reporting or not?


    "Shamim" <com> wrote in message
    news:#phx.gbl... [/ref]
    from [/ref]
    are [/ref]
    to [/ref]
    the [/ref][/ref]
    for 
    > >
    > >[/ref]
    >
    >[/ref]


    Kevin Guest

  4. #4

    Default Re: Central Database Design

    Thanks for the suggestions.

    Sh


    "Kevin Brooks" <net> wrote in message
    news:phx.gbl... 
    moved 
    break 
    Primary [/ref]
    > from [/ref]
    > are [/ref][/ref]
    down [/ref]
    > the [/ref]
    > for [/ref][/ref]
    (already 
    > >
    > >[/ref]
    >
    >[/ref]


    Shamim Guest

Similar Threads

  1. Database design
    By Ba in forum Dreamweaver AppDev
    Replies: 9
    Last Post: September 28th, 08:31 PM
  2. database design and asp question
    By Michael in forum Dreamweaver AppDev
    Replies: 2
    Last Post: June 27th, 09:23 AM
  3. Database Design
    By Mohan in forum Oracle Server
    Replies: 10
    Last Post: July 15th, 10:05 PM
  4. Database Design
    By Sampangi in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 13th, 09:28 PM
  5. Database design help required
    By Lee Bevan in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 1st, 01:34 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