increase table value [message #628770] |
Fri, 28 November 2014 05:37 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
haider_1pk
Messages: 135 Registered: March 2009 Location: PAKISTAN
|
Senior Member |
|
|
Hello friends
I have a table of salary sheet it contain 30 columns and about one million records.
So it takes some time to execute records. I used parameters but executing time is very slow. Kindly guide me how I compress table value or increase the table space value.
Regards,
Haider
|
|
|
Re: increase table value [message #628772 is a reply to message #628770] |
Fri, 28 November 2014 05:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Is the table indexed (especially columns you use in search criteria)?
Make sure you don't execute query (with no parameters) along with the "Query all records" data block property set to "Yes".
[Updated on: Fri, 28 November 2014 05:40] Report message to a moderator
|
|
|