Archives of the TeradataForum
Message Posted: Thu, 08 Mar 2012 @ 13:02:21 GMT
I was wondering if anyone could provide some advice on the use of partitioning in Teradata.
Is it possible to set up partitioning on a column that is not the primary index? If I have the PI setup on customer number which is the primary key, so truly unique, can I then setup a partition based on dates, given that access id usually done by selecting a customer number between two date ranges!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|