UDA

turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

06-30-2011
09:49 AM

06-30-2011
09:49 AM

Join Index's PI data distribution

Hi ,

We have an Join index being used in our project (on a fact table).

As everybody know- we have an PI in the Join index and as usual based on this PI ,data gets distributed across AMPs.

We would use HASHAMP(HASHBUCKET(HASHROW(PI_Col))) to find the distribution of the records in a normal table.

In a similar manner - would it be possible to find the distribution of data in the Join index ?

Thanks

Jerome

We have an Join index being used in our project (on a fact table).

As everybody know- we have an PI in the Join index and as usual based on this PI ,data gets distributed across AMPs.

We would use HASHAMP(HASHBUCKET(HASHROW(PI_Col))) to find the distribution of the records in a normal table.

In a similar manner - would it be possible to find the distribution of data in the Join index ?

Thanks

Jerome

1 REPLY

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

06-30-2011
10:22 AM

06-30-2011
10:22 AM

Re: Join Index's PI data distribution

If you're looking to estimate it before index creation, use the SELECT statement from the definition in a derived table and wrap the functions you mentioned around the DT definition. Or, after it is created, you can query the DBC tables and see the space used per amp by the index.