Current Position:Home > Database table Analyze

Database table Analyze

Update:11-30Source: network consolidation
Advertisement
<p>
{color:#339966}Hi,
I have a very basic question.
I want to know what exactly happens in the Database architecture when a table analyze is done by gathering the stats.
How does this analyze helps in performance of queries.
Thanks
Mns{color}
</p>

The Best Answer

Advertisement
hi,
Table analyze is done to get the internal details for the table like exact space used,exact blocks used,row chaining etc.
optimizer uses these details in creating execution plan for the statements for that table.
SQL> set lines 10000
SQL> select table_name,num_rows,blocks,chain_cnt,avg_row_len from user_tables where table_name='EMP';
TABLE_NAME NUM_ROWS BLOCKS CHAIN_CNT AVG_ROW_LEN
EMP
SQL> analyze table emp compute statistics;
Table analyzed.
SQL> select table_name,num_rows,blocks,chain_cnt,avg_row_len from user_tables where table_name='EMP';
TABLE_NAME NUM_ROWS BLOCKS CHAIN_CNT AVG_ROW_LEN
EMP 14 1 0 40
Regards
Edited by: NKU on Nov 5, 2008 12:28 AM
  • Database table Analyze Update:11-30

    <p> {color:#339966}Hi, I have a very basic question. I want to know what exactly happens in the Database architecture when a table analyze is done by gathering the stats. How does this analyze helps in performance of queries. Thanks Mns{color} </

  • Forms 6i Database Tables Update:10-11

    Hi there: I have installed Forms 6i Database Tables and I am able to save and retrieve forms to and from the database. Any of you have the catalog of these Forms Tables? Do you the names of the tables storing blocks, canvas, items, etc? In Forms4.5 i

  • Database table could not be deleted or recreated! Update:11-30

    Hi Experts, In process chain (Daily Load) during the deletion of contents from data target step i am facing an error "Drop cube failed in data target" & "Database table /BIC/F.... could not be deleted or recreated". Generally we fa

  • Table Analyze Automatically Update:11-30

    Hi, My database in 10g Linux envirnoment, I have found that some of the tables in database are analyze autometically. Is it possible in 10g that oracle will analyze the tables autometically at perticular time. Please help. AnandBy default, 10g ships

  • Reg:How to delete the column in table control also from database table. Update:10-11

    Hi Experts, Once again thank u all for giving the responses. one more doubt is how to delete the columns of table control and also the record shold delete from ztable. With Regards, Saroja.P.Hi, If you want to delete the rows in the table control and

  • Help needed in reading text file to database table Update:10-11

    Hello experts, i have to insert the values from the column of this text file and insert them in my database table. I have done a few file to table insertions but i'm having some trouble with this one. Any suggestions plz thanks liab_report      1.00 

  • Displaying data in a tree from database table Update:10-11

    Hi, I want to display data from a database table (mara-matnr) in a tree structure. I went through the coding of SBSPEXT_HTMLB. There static data was taken in to wa_tab. But there I want to bring data from a database table into wa_tab. For this I crea

  • Sending data from SAP-BW ODS to R/3 database table/ view Update:10-11

    I need to store data in an ODS in BW from an oracle view & then send this data to SAP R/3 so that the same data can be used by SAP-ABAP for making a BDC program ( i.e. finally storing it in some database tables in R/3). Is it possible to do that?? if

  • Database Table cannot be found when Verify Database Update:10-11

    Post Author: brentlaw CA Forum: Other I have been using CRW 7 for many years.  I recently upgraded to XI (I have current version).  I can open existing reports and create new reports fine.  The problem is when I Verify Database I get an error message

  • Database table update issue Update:10-11

    Hello experts, Need your Help... I am trying to update database table using Update command. And I am doing COMMIT WORK AND WAIT. after the successful update. But my code sometimes does not work and the table is not updated. Sometimes the code works a