Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2009
    Posts
    39

    Data warehouse and Index(es)

    I looking for solutions about index in data warehouse database.

    what is best practice?
    if index(es) not created load is fast, but query is slow.

    how this solving?
    if we want index(es) and velocity of insert records in table.

    because if index(es) created, load in table is slow or maybe I'am wrong beacuse I don't no which velocity of insert records is on good server.


  2. #2
    Join Date
    Jul 2009
    Location
    Michigan
    Posts
    125
    If you can load at night but query during the day then during the load process: drop the index, load the data, then recreate the index.

  3. #3
    Join Date
    Sep 2009
    Posts
    39
    Quote Originally Posted by MarkATrombley View Post
    If you can load at night but query during the day then during the load process: drop the index, load the data, then recreate the index.
    this is OK.

    but, what if I have many records in table?

    maybe few bilion record in table and load new data, drop index lasts few hours and create lasts few hours?

    what then?

  4. #4
    Join Date
    Jul 2009
    Location
    Michigan
    Posts
    125
    Then you buy a bigger machine. A lot bigger. And faster.

  5. #5
    Join Date
    Sep 2009
    Posts
    39
    Quote Originally Posted by MarkATrombley View Post
    Then you buy a bigger machine. A lot bigger. And faster.
    thanks

Posting Permissions

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