Skip to Main Content

How testing impact of index during insert

1046786Mar 27 2014 — edited Mar 27 2014

Hi all,

I have to test if adding a particular index on a table, has some efforts or impacts on Insert queries.

How can I do it?

I'm thinking about 2 ways:

1) Create a small stored procedures that insert 2k rows (for example), and retrieve the execution time with/without the index

2) Do the point 1) using some better tools like DBMS_PROFILER to get a more precise execution time...

That's all: have you got any suggestions? Should I do some work adding/removing the index? I'm thinking about update some Oracle statistics...

Thank you so much!!

Post Details
Added on Mar 27 2014