Home » RDBMS Server » Performance Tuning » Full table scan
Full table scan [message #217287] Thu, 01 February 2007 08:38 Go to next message
rawat_me
Messages: 45
Registered: September 2005
Member
Hi All,
In the below query i am attaching the Explain plan

I want that is there any way i can reduce the FULL Scan read of the table TDEPT. The whole query is running fine except the FULL Sacn of table TDEPT whose COST is coming as 685.

thanks

Report message to a moderator

Re: Full table scan [message #217291 is a reply to message #217287] Thu, 01 February 2007 09:00 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Hi,
Providing the description of the tables and indexes is a good idea.

By
Vamsi

Report message to a moderator

Re: Full table scan [message #217292 is a reply to message #217291] Thu, 01 February 2007 09:12 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
And not posting proprietry format attachments is another good tip - just include the explain plan in your post, in a set of [CODE] tags
I for one will not open an XLS spreadsheet from a source I don't know.

Report message to a moderator

Re: Full table scan [message #217641 is a reply to message #217287] Sat, 03 February 2007 11:28 Go to previous message
michael_bialik
Messages: 621
Registered: July 2006
Senior Member
You may try hint:

SELECT /*+ USE_NL(Deptrlp) */ <the rest of your statement>

Verify that you have an index on Ps_Gl_Dept_Id_c column.

HTH.

Report message to a moderator

Previous Topic: Insert from 2 million rows
Next Topic: Help Required in Tunning
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 00:37:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.