-
demonstrated how bad HWM would be for FTS
I asked to demonstrate what would affect performance if I have a high number of high water mark. Anyway, below is what I have in mind, but I need to get some inputs/advises.
1. let's say I have a table with 100k of rows.
2. delete the data
3. DBA_SEGMENTS is unchanges in bytes which is obvious.
how can I capture the time of the query and show that HWM would take a lot more time to scan the entire table up to the HWM even there is no records.
thanks
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
|