Skip to Main Content
Forums

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!

White Spaces, Tab and Line Breaks causes slow in query execution? What is the main reason behind it

2741914Aug 28 2014 — edited Sep 4 2014

Hi All,


I am facing weird issue in SQL query. Intitally i wrote the query with white spaces, tabs and Line Breaks after executing it slows down the database and finally i have to restart the database again. But after removing the whitespaces the query ran fine. I dont know what is the issue causing this slow execution but after removing white spaces from query everything works fine. I also confirmed with the explain plans both after removing white space and before had same results.

I am using PL/SQL DEVLOPER TOOL, SQL developer, Toad and Oracle 11g.

***************************************************************

For eg.( in reference to my Original Query):

Select

*

from

dual;

****************************************************************

(After removing white spaces)

select * from dual;

*****************************************************************

What would be the reason behind white spaces causing the slow execution?

Please let me know if you need any further information on my issue.


Thanks in Advance,

HP
This post has been answered by RogerT on Aug 28 2014
Jump to Answer

Comments

Christian Berg-0racle

Shortest answer: No.

If your client wants to use Excel and not the Oracle product they pay for, then contact Microsoft.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 2 2014
Added on Aug 28 2014
4 comments
1,680 views