What is a full table scan and what is the ideal rate/min for a FTS?

Questions by ananth_kimi

Showing Answers 1 - 3 of 3 Answers

parthokonar1

  • Sep 26th, 2007
 

FTS means the oracle server reads all the records from the concerned table. And it all depends on the size of the table/ partitioned table. What you say if a table consists of 10 million of records. so we musr avoid FTS. And  after all Oracle is build for searching.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions