Home » SQL & PL/SQL » SQL & PL/SQL » Oracle table Maintainance
Oracle table Maintainance [message #237316] Mon, 14 May 2007 02:52 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Hi,

My version is 9i.

In a table had one lakh records are there.it contains lot of null values and duplicate values , retrieve records time is very slow . what are steps are doing now that table is efficent and any more process are there?

Any body help to me..


Regards,

Arun..
Re: Oracle table Maintainance [message #237328 is a reply to message #237316] Mon, 14 May 2007 03:04 Go to previous message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
Maybe you can post explain plan / create-statements / sql which is slow.

Otherwise we are shooting in the dark.
Previous Topic: cursor is open or not?
Next Topic: No copy parameter
Goto Forum:
  


Current Time: Fri Dec 02 14:23:19 CST 2016

Total time taken to generate the page: 0.41945 seconds