Company official library has 240 w (oracle10g) a table data, create an index plan in a certain field, ask, after the index creation, insert a data will be slower than the original?
thank you

CodePudding user response:

This is bad to say, you can refer to specific implementation plan, the other for such a big table whether considering the partition?

CodePudding user response:

The hardware performance of the machine, the value of the index columns repetition rate have relationship;

If it is the needs of the business, plus it, will not slow much; (a)