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

sql - VB.NET Operand type clash: date is incompatible with int error -

SVG stroke-linecap doesn't work for circles in Firefox? -

python - TypeError: Scalar value for argument 'color' is not numeric in openCV -