Test case when index size can grow than table size and effect of rebuild index
Test case preparation I am going to create test case to simulate different index test cases Test case 1:-First we create procedure to parallel insert in 10 sessions.The insert query will insert data based on random values generated from select query.Please note I will run gather stats after… Continue Reading Test case when index size can grow than table size and effect of rebuild index
- Posted on:
-
Author:
debasis maity
- Categories: General Performance tuning
- Tags: cluster factor, index size
- Leave a comment: Test case when index size can grow than table size and effect of rebuild index