The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.
Just really want to know what storage structure Oracle uses, is it Serial, Direct Access, Sequential ? I need to do a poster(a 1 page essay) on storage structure for an assignment, but need to relate it to Oracle. Tried looking in a Oracle book but did'nt find anything. Thought that I would ask in here as theres quite a few people in here who know there stuff. So I would appreciate any help, there maybe a cookie up for grabs :).
Thanks for the reply. Yeah I would have thought the same as you as the only sensiable option is a Direct Access using an index. As really sequential and serial access are basically used for back up purposes. I'll have to do a little more research on this, but I am pretty sure that it would use the Direct Access method.
Hmm, good question. Don't quote me on this, but I'd imagine in theory it could be a combination of structures depending on how the dba has built the database.
I mean, the whole point of an index is to speed up access. Therefore it must use a different kind of access to an unindexed table. For example a primary index would be direct access I'd guess, as the table is physically held in the order of the key. When building a primary index, it takes a lot longer to do, because the data manager physically sorts and stores the data in the order of the index.
Dont know if thats any help. Post again if you come up with anything. I'd be interested to hear.
I mean, the whole point of an index is to speed up access. Therefore it must use a different kind of access to an unindexed table. For example a primary index would be direct access I'd guess, as the table is physically held in the order of the key. When building a primary index, it takes a lot longer to do, because the data manager physically sorts and stores the data in the order of the index.
Dont know if thats any help. Post again if you come up with anything. I'd be interested to hear.
Just really want to know what storage structure Oracle uses, is it Serial, Direct Access, Sequential ? I need to do a poster(a 1 page essay) on storage structure for an assignment, but need to relate it to Oracle. Tried looking in a Oracle book but did'nt find anything. Thought that I would ask in here as theres quite a few people in here who know there stuff. So I would appreciate any help, there maybe a cookie up for grabs :).