| table too large [message #65381] |
Wed, 01 September 2004 02:47  |
Abhinav Nigam
Messages: 49
Registered: August 2004
|
Member |
|
|
hi all
one of tables which is primarily used to fetch data for reporting is having something around 4 million records. what can i do on the table level to fasten the query apart from creating indexes.
Regards
Abhinav
|
|
|
|
| Re: table too large [message #65382 is a reply to message #65381] |
Wed, 01 September 2004 03:15  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
Hi,
You can do several things:
1) Create indexes
2) Convert the table to a partitioned table
3) Use Parallelism when selecting
4) Redesign the database into smaller tables
Etc.
Best regards.
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
