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!!