Data Warehousing Community Forum
February 09, 2012, 01:13:02 pm

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Difference b/n Index and Materialized View  (Read 798 times)
Raj2007
DW Apprentice
**

Reputation: +3/-0
Offline Offline

Posts: 25


Lightning for DW Forum


View Profile
« on: July 02, 2007, 08:55:18 pm »
Hi,
Can any of you describe the major difference between an Index and a Materialized View?

On what basis, these two objects can be differentiated?

This Question was asked a great recruiter...!
« Last Edit: July 03, 2007, 10:33:10 am by Sipra » Logged
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« Reply #1 on: July 03, 2007, 10:52:01 am »
Dear...!

I hope the recruiter forced you to answer this question...!

There is way to differentiate between an Index and Materialized view.

A Materialized View can be accessed directly by using a SELECT statement where as an Index can't be done..!

Hope this is the right way to be answered.
Logged
Sipra
Founder

www.dwforum.net
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: