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
Messages: 144
Registered: February 2007
Location: india
Senior Member


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..


Re: Oracle table Maintainance [message #237328 is a reply to message #237316] Mon, 14 May 2007 03:04 Go to previous message
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: Wed Jun 28 14:33:06 CDT 2017

Total time taken to generate the page: 0.16297 seconds