COOLINTERVIEW.COM DATABASE TERADATA DETAILS

Question :

How does indexing improve query performance?

Answer :

Indexing is a way to physically reorganise the records to enable some frequently used queries to run faster. The index can be used as a pointer to the large table. It helps to locate the required row quickly and then return ot back to the user. or The frequesntly used queries need not hit a large table for data. they can get what they want from the index itself. - cover queries. Index comes with the overhead of maintanance. Teradata maintains its index by itself. Each time an insert/update/delete is done on the table the indexes will also need to be updated and maintained. Indexes cannot be accessed directly by users. Only the optimizer has access to the index. © CoolInterview.com Today's Special : Free eWeek Magazine Subscription. Absolutely Free! A D V E R T I S E M E N T

If you have the better answer, then send it to us. We will display your answer after the approval.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code:*
	Inform me about updated answers to this question

   

Category	Teradata Interview Questions
Rating	(0.0) By 0 users
Added	4/4/2008
Views	301
Rate it!	* * * * * * * * * * * * * * *
Free Offers	300 Free Magazines for you. No credit card required. No Shipping Charges. Absolutely Free for 1 Year.

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when better answer is posted!
Email: