-
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
-
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"
-
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
-
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
-
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"
-
Hi Tom,
For every week we will inserting close to 2 Million records
regards
anandkl
anandkl
-
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
-
Yeah, it sure sounds like a case for benchmarking.
-
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
-
Increase? I doubt it. Try it and let us know.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|