What is the use of having index's on table?



What is the use of having index's on table?..

Answer / lakshma naik

to fetch the data quickly

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Teradata Interview Questions

What are the newly developed features of Teradata?

0 Answers  


Name the five phases that come under MultiLoad Utility.

0 Answers  


Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance

6 Answers   Cap Gemini,


What type of indexing mechanism do we need to use for a typical data warehouse?

0 Answers  


Explain Teradata performance tuning and optimization?

0 Answers  






What's the syntax of sub string?

1 Answers  


In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??

3 Answers   CTS, Lexicon,


what is the difference between start schma and Fsldm?

5 Answers   Intel,


i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me

8 Answers   Satyam,


What is the purpose of indexes?

0 Answers  


Differentiate database data and data warehouse data?

0 Answers  


How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?

4 Answers   Comsys, IBM,


Categories