Indexed Organized tables.
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Indexed Organized tables.

  1. #1
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840

    Indexed Organized tables.

    Hi Friends,
    We are planing to migrate a table to index organised table, the table has two columns and forms a perfect match for IOT.This table is higly insert/delete table.I want to know if we migrate this table to IOT will we benefit in insert performance i.e will the time taken by insert be reduced. I also read in oracle documentation the we can COMPRESS the index keys, we are planing to implement this, will this have any impact in insert performance.

    Please help...

    regards
    anandkl
    anandkl

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    You dont gain any performance gain on Inserts but lag.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Why,
    Since it would be using the same block to store data and index, so it should be much faster

    please explain your answer.

    regards
    anandkl
    anandkl

  4. #4
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    I think it should be little faster than
    inserting in regular table and maintaining a separate index alltogether.

    But, is this table big enough that it needs an index at all?
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Insert into heap organised table ( No assciated indexs ) Vs IOT, which one will be faster?

    The Q was inserting into normal table ( before ) and later conerting to IOT, which one will be faster. I guess former one.

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  6. #6
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi Tom,
    For every week we will inserting close to 2 Million records

    regards
    anandkl
    anandkl

  7. #7
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    I think it's good idea. Why don't you test it and post the results.
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  8. #8
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Yeah, it sure sounds like a case for benchmarking.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  9. #9
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840

    anandkl

    Hi Friends,
    I am sorry if i have confused you, actually the existing table is a table which index as well.So if we convert this into IOT, would insert performance increase.

    I am sorry if i have confused you people.

    regards
    anandkl
    anandkl

  10. #10
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Increase? I doubt it. Try it and let us know.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

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



Click Here to Expand Forum to Full Width