SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting Long time to execute select count(*) statement.

729722Dec 17 2009 — edited Dec 17 2009

Hi all,

My table have 40 columns and it doesn't have the primary key column. it contain more than 5M records. it's taking long time to execute simple sql statement.
Such as select (*) take 1min and 30 sec. If i use select count(index_colunm) then it finished with in 3s. i did the following workarounds.

Analyzed the table.
created required indexes.

yet getting the same performance issues. please help me to solve this issue

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 14 2010

Added on Dec 17 2009

3 comments

1,027 views