Creating indexes on large table

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

I have an Oracle Database table that has about 43 million records. I’m intended to create and index on one of the columns. The column data type is DATE. I need to know how properly size the index. The table is not partioned.

Database Administration Database Development Database Programming Oracle Software Development

Project ID: #17664285

About the project

22 proposals Remote project Active 5 years ago

22 freelancers are bidding on average $126 for this job

adeeladeel1234

Please review my profile and send me message to discuss your requirements in details

$35 USD in 1 day
(25 Reviews)
4.7
Viktorburuncz

Hello Madame / Sir, For this request you have to provide the tablename then I can help you. Thanks Viktor

$15 USD in 1 day
(1 Review)
3.1
pratikgedia

Have created indexes on table that are more than 200+ million records and improved the performance of the database

$25 USD in 1 day
(2 Reviews)
3.2
rajsunique

Hi, I have a good experience of oracle and pl/sql and i would be able to help you if you choose my bid. Thanks.

$25 USD in 1 day
(1 Review)
2.5
hammadabbasi01

Hi , I am providing below services. Oracle 10g, 11gR1 & R2 RAC implementation and administration • Data development support and Administration using oracle 9i, 10g ,11g and 12c • Backup/Recovery, performance tu More

$25 USD in 1 day
(2 Reviews)
1.2
HanyWaseem4

15 year oracle experience . 100% client satisfaction is my target . i love my job so do my best to complete it well .

$20 USD in 1 day
(0 Reviews)
0.0
itsparx

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I am a Fu More

$25 USD in 1 day
(0 Reviews)
0.0
pcworkshops

I would confirm exact requirements by means of Skype conversation or questionnaire, or you may have spec already drafted. I would once the requirements are confirmed, deliver in 3 days. With my experience, this may b More

$25 USD in 3 days
(0 Reviews)
0.0
moondba

Experience in configuring Oracle ,SQL Server databases, Monitoring, Performance tuning and daily tuning task

$25 USD in 1 day
(0 Reviews)
0.0
guilhermebrike

I can help on the doubts about creating the index on the mentioned large table, we should not have any issues, on creating the index, i would take some time, but no problems on the date column, but we can together unde More

$15 USD in 1 day
(0 Reviews)
0.0
efsweeney

I have over 25 years of experience with Oracle databases. I believe I can assist you with your request.

$25 USD in 1 day
(0 Reviews)
0.0