Indexes in Teradata -


how enable/disable indexes in teradata database?

i want disable indexes , update , enable indexes in teradata.

if enable/disable option not available in teradata, in sense how can achieve ? if use drop indexes, how can recreate indexes tables?

teradata gives way create table without choosing primary index (if sure of column).

you can create table no primary index. here sample of how so:

create table <table name>  (<columnname> <datatype>, <columnname> <datatype>)  no primary index ; 

Comments

Popular posts from this blog

android - Why am I getting the message 'Youractivity.java is not an activity subclass or alias' -

Making Empty C++ Project: General exception (Exception from HRESULT:0x80131500) Visual Studio Community 2015 -

How to fix java warning for "The value of the local variable is not used " -