Teradata: How can we know the indexed column in a table?
Answer / Mohd Muneebur Rehman
In Teradata, you can use the DESCRIBE command with the INDEXES clause to view information about the indexes on a table. For example:nDESCRIBE TABLE <table_name> INDEXES;nThis will display information about all the indexes defined on the specified table.
| Is This Answer Correct ? | 0 Yes | 0 No |
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
• What is oracle Architecture?
How will you force database to use particular rollback segment?
What Does DBWR do?
Teradata: How can we know the indexed column in a table?
What is PGA?
How will you swap objects into a different table space for an existing database?
What does LGWR do?
How to find the SGA Size
What is the function of ARCH?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
Can a Tablespace hold objects from different Schemes in Oracle?