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
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: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Hi,
Providing the description of the tables and indexes is a good idea.

By
Vamsi
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.
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: 611
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.
Previous Topic: Insert from 2 million rows
Next Topic: Help Required in Tunning
Goto Forum:
  


Current Time: Wed Dec 07 09:03:19 CST 2016

Total time taken to generate the page: 0.05666 seconds