-
After next extent change, count didn't matching
After next extent change, my one table become strange and sql work differently with original backup table. I will post sql and schema, can you see why this sql show 0 count instead of about 9500 count.
This is changed sql and table: count = 0
SELECT COUNT(*)
FROM SDAM_ILBI A
WHERE A.IL_DATE BETWEEN '20100201' AND '20100208'
AND A.SABUN NOT IN (
SELECT TM_SABUN
FROM SKWASO_bk20100106
GROUP BY TM_SABUN
)
And this is backuped original table with query : count =9634
SELECT COUNT(*)
FROM SDAM_ILBI A
WHERE A.IL_DATE BETWEEN '20100201' AND '20100208'
AND A.SABUN NOT IN (
SELECT TM_SABUN
FROM SKWASO
GROUP BY TM_SABUN
)
I think something is wrong with reorg or next extend or index.
Thank you.
Here is schema. you can download and put it in DB.
http://dl.dropbox.com/u/529936/skwaso.zip
Tags for this Thread
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
|