Conversion of Primary to Secondary index
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home       Guidelines    Member List
Welcome Guest ( Login | Register )
        


This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


Conversion of Primary to Secondary index Expand / Collapse
Author
Message
Posted 1/10/2006 2:01:53 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 10/24/2008 12:51:19 AM
Posts: 49, Visits: 5
Hi,

Is there a way to convert Primary index to Secondary index ?


Thanks and Regards


Akhil Bansal
Post #3331
Posted 1/10/2006 4:30:40 AM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 7/24/2008 8:31:03 AM
Posts: 109, Visits: 22
You will need to recreate the table with a new Primary Index and make the current PI as the SI.
Post #3332
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 12:21am

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.063. 7 queries. Compression Disabled.