Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Large Datamart Crosstab Table
I might be able to help… let me see if I understand:
Your existing table has 363 million rows. Am I right to guess that it looks something like the "EXISTING_TABLE" below?
EXISTING_TABLE
If your new table looks like the "NEW_TABLE" below- then we can count the distinct ID column values in EXISTING_TABLE to determine its size.
NEW_TABLE
![]() |
![]() |