Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Eben Thomas
Starting Member
1 Post |
 Posted - 2011-08-26 : 06:23:45
|
| Hello,I am working with an online application with the database in Oracle 10G. We have a table with 10 million rows and this table is subjected to grow in future also. Moreover we cannot archive some of these rows as these records are required for referencing.We have all necessary indexes on the table but query this table takes a lot of time especially when it is joined with other tables. Request you to please suggest me some methods with which I can manage this table in a better way so that queries joining this table would execute faster..Thanks..Eben Thomas |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2011-08-26 : 06:27:56
|
| you might want to try an oracle specific forum. This is a microsoft sql server one.http://www.dbforums.com/oracle/for example.SQL Server suggestions probably wont help. Table partitioning etc probably doesn't translate well to oracle.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-08-26 : 09:00:27
|
| Even though this is a sql server forum only, partitioning would be the way to go. Partitioning as a concept is the same across all db platforms and it basically means that you create a set of partitions (based on a partitioning column) that are logically connected together as a table. You could i.e. partition on a date column and your partitioning function could divide the rows in 12 partitions, one for each month in a year. For implementation specific advice you should do as Charlie suggests, go to dbforums.- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
|
|
|
|
Managing a Large Table