Home » SQL & PL/SQL » SQL & PL/SQL » ROWID Storage in Oracle
ROWID Storage in Oracle [message #248425] Fri, 29 June 2007 00:44 Go to next message
manchalravi
Messages: 15
Registered: June 2007
Junior Member
Hi Experts,

I want to where the ROWID in oracle database is stored. I know that this is not stored in database. But where is this stored?

Please respond to this.

Thanks,
Ravi
Re: ROWID Storage in Oracle [message #248431 is a reply to message #248425] Fri, 29 June 2007 01:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No where.
In your home, where do you store your address?

Regards
Michel
Re: ROWID Storage in Oracle [message #248433 is a reply to message #248431] Fri, 29 June 2007 01:10 Go to previous messageGo to next message
manchalravi
Messages: 15
Registered: June 2007
Junior Member
Thanks for your reply!

I have got same kind of answer for somebody.

You this is a reference. right? but oracle should remember this when we are searching for something.. How does it work in oracle?

Regards,
Ravi
Re: ROWID Storage in Oracle [message #248444 is a reply to message #248433] Fri, 29 June 2007 01:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
oracle should remember this when we are searching for something

It doesn't have to.

Your postman can give you your letters even if he does not know your address.
He just has to follow the address your correspondant put on the envelope.
Oracle does the same thing.

The only place where Oracle stores rowids is in indexes, to speed up the queries but it can leave without them.
It can just scan the table to find what you want (as the postman can go all over the town to find you).


Regards
Michel
Re: ROWID Storage in Oracle [message #248452 is a reply to message #248444] Fri, 29 June 2007 02:01 Go to previous message
manchalravi
Messages: 15
Registered: June 2007
Junior Member

Thanks Michel.
Previous Topic: What is the functionality of NO_UNNEST hint?
Next Topic: Using % operator
Goto Forum:
  


Current Time: Thu Dec 08 04:27:31 CST 2016

Total time taken to generate the page: 0.08594 seconds