GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle  >  Scenarios

 Print  |  
Question:  If the large table contains thousands of records and the application is accessing 35% of the table which method to use: index searching or full table scan



February 02, 2007 18:50:53 #6
 Surya Peri   Member Since: Visitor    Total Comments: N/A 
RE: If the large table contains thousands of records a...
 
Hi,
15% of 100 million rows is still a lot of rows and would take lot of time if there is a full table scan.
     

 

Back To Question