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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL Statement with and without WHERE clause

GQNov 9 2015 — edited Nov 9 2015

Hi,

Can any one describe me and help to resolve one issue we are facing when we run the following SQL statements?

1. Select * from ABC; (This takes 1 to minutes to return with data. ABC table contains about 150,000 records with one column of XML data. Even if there are o rows in the table it takes 1 minute)

2. Select * from ABC where status = 0; (When we run this statement it takes miliseconds as status is indexed column. )

What to do in this case to optimize the output of the first statement without where clause?

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 7 2015

Added on Nov 9 2015

11 comments

1,402 views