hello all,
i want to share my problem with u all.my problem is i ve created two tables the primary key of one table is the foreign key of the other table.
when i did select statement to show all the data of the first table it did not come properly so,i did some formatting like page size,linesize setting.i also did column setting by column column_name format a3; statement.after running this statement the numbers which i stored in...

hi all,
can anybody tell me.what is analyze statement in oracle?what is the use of analyze statement and how it helps in explain plan?

second is,what is associate statistics?what is it function? :confused: