Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2007
    Posts
    12

    Question Unanswered: Indexes used in Data warehousing ?

    Hi friends,

    Can anyone please share your idea on indexes and what are all the indexes are used in Data warehousing. Pleas look at the following Questions.

    • How many types of indexes are there?
    • In Data warehouse which indexes are used?

    Thanks...

  2. #2
    Join Date
    Feb 2007
    Location
    Bratislava, Slovakia
    Posts
    85
    1, index type: B-tree, bitmap, function based
    2, all - depends by situation. check documentation
    Beer contains just a small amount of vitamines - that's why it's necessary to drink lot of it.

  3. #3
    Join Date
    Jun 2007
    Posts
    12

    Question

    Quote Originally Posted by baloo99
    1, index type: B-tree, bitmap, function based
    2, all - depends by situation. check *documentation*

    Can you please whats that Documetation that you have mentioned in your reply ? Can you provide me any link...

  4. #4
    Join Date
    Feb 2007
    Location
    Bratislava, Slovakia
    Posts
    85
    http://download-uk.oracle.com/docs/c...0a.htm#2062405
    here you have examples.
    warnings:
    * do not use global indexes over partitioned table - exchange partition fails, worse maintenance
    * bitmap indexes are sensitive for update of indexed columns. causes deadlocks in concurrent environment
    Beer contains just a small amount of vitamines - that's why it's necessary to drink lot of it.

Posting Permissions

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