This forum is currently locked. You can't register or post questions at this time. (read more)

NO_EXPAND Hint

All posts relating to Oracle database administration.

Moderator: Tim...

Raaj A
Senior Member
Posts: 51
Joined: Wed Mar 07, 2012 7:08 am

NO_EXPAND Hint

Postby Raaj A » Fri Nov 02, 2012 5:52 am

Hi Tim,

What is exactly "NO_EXPAND" hint ? can we use "NO_EXPAND" hint permanently in a query to increase the efficiency of the sql query?

Thnaks
Raaj

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: NO_EXPAND Hint

Postby Tim... » Fri Nov 02, 2012 8:44 am

Hi.

The manual explains what is does:

http://docs.oracle.com/cd/E11882_01/ser ... SQLRF50502

Hints tell the optimizer to do something that it may not otherwise do. As a result, in some situations a hint may improve performance, in others is may reduce it. You should try not to use hints unless you have a documented case where it improves performance. Even then, you should attempt to remove them with subsequent patches and updates to see if the particular issue you faced has been resolved in the updated optimizer.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

Raaj A
Senior Member
Posts: 51
Joined: Wed Mar 07, 2012 7:08 am

Re: NO_EXPAND Hint

Postby Raaj A » Fri Nov 02, 2012 9:23 am

Thankyou so much.....

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: NO_EXPAND Hint

Postby Tim... » Fri Nov 02, 2012 11:03 am

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 9 guests