Re: concept of indexes
Date: Wed, 12 Feb 2003 12:35:09 -0800
Message-ID: <3e4a94ab$1_2_at_binarykiller.newsgroups.com>
> Are indexes in oracle sort of like pointer variables or passing by
reference
> in C++?
Yes and no. Indices DO contain "pointers" instead of the whole record data. An index is most analogous to an index in the back opf a book. You search the index for your target keyword, and the index telly you where it's at. Same thing with a DB index, you search for a value, and the index tells which record(s) holds the value. Therefore, the index has two things in it: The indexed value, and a "pointer" to the actual record.
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Wed Feb 12 2003 - 21:35:09 CET