GeekInterview.com
Series: Subject: Topic:
Question: 27 of 118

What is the difference between Aggregate Awareness and Index Awareness? Where are they used and how can be used?

Asked by: Latha03 | Member Since Jan-2007 | Asked on: Jan 23rd, 2007

View all questions by Latha03   View all answers by Latha03

Showing Answers 1 - 1 of 1 Answers
gaurav07

Answered On : Oct 7th, 2010

View all answers by gaurav07

Aggregate awareness: First understand the usage of aggregate awareness. information is store in database is in summary form.instead of recording the date and time each time a certain product is sold, the datawarehouse could store the quantity each hour, each day or each week.here comes the use of aggregation which is used in 2 ways.1) to save the storage space : use of aggregate greatly reduces the space2) to improve the performance of BI tool: when queries run they take less processing time and users get their information quickly.Index awareness: Ability to take advantage of the indexes on key column to speed data retrieval.you set up index awareness in designer, you tell designer which database columns are primary key and foreign key.select particular object oper the properties of object, open 'keys' tab.click insert and add respective primary key and foreign key.Designer generate SQL that filters in the most efficient way using index awareness.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.