|
-
Hi All
11.which two statements about row migration are true? (Choose two)
a.Row migration is caused by a PCTREE value set too low. b.Row migration can be resolved using the ANALYZE command.
c.Row migration can be reduced by choosing a larger block size.
d.Row migration means that row pieces are stored in different blocks.
e.Queries that use an index to select migrated rows perform additional I/O
my answer is A & B .But i feel A & D is also right.. i am confused can somebody clarify...
(coz thru d i can detect migrated rows and then rectify them )
regards
Hrishy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|