| IOT vs Normal relational table. IOT taking more time in data loading [message #62058] |
Wed, 23 June 2004 00:09 |
Shibaji Ghosh
Messages: 39
Registered: April 2002
|
Member |
|
|
Hello,
I was trying to do a benchmark on perfromance aspects between normal table and an IOT. I have taken a table having 105 fields and with 5 million rows. The pk index in an IOT consists of a composite key on two fields (<date_field>,<varchar2_field>). The normal relational table also consists of an index on the same two fields. I am using SQL LOADER to insert rows in both the tables. I tried in both direct path and convetional path load.
Here are my observations : Load in IOT is taking 3 times more than a normal table. But response rate is fast. My question is
1.> Are the benchmark results go by normal Oracle process ?
2.> Is it always that IOT will take 3-4 times more time in loading same set of data when compared with a normal indexed table ?
3.> Do we have some options of fastening the IOT stuff when it comes to data load.
Thanks in advance.
Shibaji
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
