Can any one explain me about the concept of clusters in oracle, it would be better if some one illustrate it by an example. I tried a lot in Google to get the some idea about clusters but with no luck.
All the links which i got after googling had given me some theoritical information that clusters are used to provide faster access to data by storing the relevant data in a physical area so that when two tables accessing data they dont have to move over two data files they can find it in same place(if the tables are using a cluster).
Needed a pratical example to check out the execution speed etc., I know its not so simple to explain, This EE has got many talented people. I had just started to use this site hardly for a month and seen a various experts comments and articles which are really helpful.
I hope my question will be answered in a best possible way..