13 October, 2020
Other than primary index columns if we are using in the where clause, To get fast retrieval data to take the second index on the columns.
Inclined to build a profession as Teradata Developer? Then here is the blog post on, explore Teradata Training
Sel* from a party where pcode=20; Party
Sub table content added and removed according to the main table content, which is a burden to the system.
Sub table may in the same Amp(or) it may be indifferent Amp.
|S.I ROW ID||Column value||P.I row ID|
Sel * from the party where P-Code between 20 and 33
USI: Create table<table name>unique index(column name)
NUSI:- Create table<table name> index(column name)
USI: Create unique index idx- party CD(party code) on the party;
NUSI:- Create index idx- party CD(party code) on party
Create index (party code) order by values on the party;
Named index dropping: Drop index<index name>on<table name>
Unnamed index dropping: Drop index(Column name)on<table name>
Create set table party test fall back (party id integer, party name varchar(30)upper case, party income integer check(party income>5000), party code integer) unique primary index(party id)unique index(party code)
There is a table with primary key and a unique key is available what types of index the system create by default?
Ans:- As the primary key give high priority, it takes UPI on the primary key and USI on unique
a) UPI:- UPI on the primary key column and unique key column as USI
b)USI:- USI on the unique key column
a) As per BIET Names are limited to 30th character
b) A name can be a combination of A-Z, a-Z,$,#,-
c) Object Name is unique in tera data
In this situation instated of secondary index row ID/row hash sequence, actual values will be ordered so
that this index is useful for range-based query operations.
General we used select, insert, etc statement
‘IT’ as deptCharacter Literal
40 as code Numeric literal
|Party id||Party name||dept||Code|
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .