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' -

python - How do I create a list index that loops through integers in another list -

c# - “System.Security.Cryptography.CryptographicException: Keyset does not exist” when reading private key from remote machine -