What is mean by ANALYZE command in oracle?
Wht is the purpose of ANALYZE command. if we ANALYZE the table/index wht happens to the object and how it improves the performance? Because why i am asking is, I have table which is contain fuction based index like UPPER(column_name). When i execute the below query, it is getting full table access.
select * from table_name where upper(column_name) = upper('ABC');
At the same time, when i analyze the table it is getting index based scan in the explain plan output.
ANALYZE TABLE table_name COMPUTE STATISTICS;
One more thing is when i execute DBMS_STATS package also the table is getting full table access. See my execute command below.
EXEC DBMS_STATS.gather_index_st
Can anyone share with me the solution of this? Thanks in advance.
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
Enterprise software, also known as enterprise application software (EAS), is computer software used to satisfy the needs of an organization, including businesses, schools, interest-based user groups, clubs, charities, or governments. Services provided by enterprise software are typically business-oriented tools such as online shopping and online payment processing, interactive product catalogue, automated billing systems, security, enterprise content management, IT service management, customer relationship management (CRM), enterprise resource planning (ERP), business intelligence (BI), project management, human resource management (HR), manufacturing and supply chain management, enterprise application integration (EAI), and enterprise forms automation. Enterprise software is often available as a suite of customizable programs that require specialist capabilities.
TRUSTED BY
