Data Warehousing Community Forum
February 08, 2012, 10:17:59 pm

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Fast accessing of rows from a table ?  (Read 894 times)
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« on: June 27, 2007, 04:21:17 pm »
Hi all,

A general Interview question,
What is the way of getting fast access to fetch a row from a table?

I answered in the following way -
Creation of indexes on tables will provide fast access to rows in a table.

But he told - No Indexes are there.
Without indexing, Suggest your answer to fetch rows fastly from a table?
Logged
Sipra
Founder

www.dwforum.net
Raj2007
DW Apprentice
**

Reputation: +3/-0
Offline Offline

Posts: 25


Lightning for DW Forum


View Profile
« Reply #1 on: June 27, 2007, 07:45:30 pm »
Hi Sipra,

Just he confused you a little bit to test you dear..!

Without Indexing means, it is only possible to use a ROWID function there.

ROWID - It is a Pseudo column attached to each row of a table.
It is 18 character long, blockno are the components of ROWID.
Logged
unknown
DW Apprentice
**

Reputation: +8/-0
Offline Offline

Posts: 44



View Profile
« Reply #2 on: September 08, 2007, 09:35:00 pm »
By Indexing only, it is possible to access the tables fastly.

No Idea on ROW ID Undecided. How you will access fastly by using this ?
Logged
Thanks
Unknown Smiley
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: