Home » SQL & PL/SQL » SQL & PL/SQL » Optimized Database Creation (Oracle 10g)
Optimized Database Creation [message #324586] Tue, 03 June 2008 04:13 Go to next message
Messages: 266
Registered: April 2008
Location: India
Senior Member
I have to create a database with around 45 tables. I have created one small database earlier but without any tuning in mind and generally didn't taken any care for its optimization.
This project is a big one and I am new to it so please suggest me some precautions or rules or tips to create a databse that should be tuned in term of space allocation, indexing and others.

Please give me some best links if possible or suggest me some guidelines for creating a good database. Also please advice as how to check the health of an exising database.
Too many questions.... but please look into this.
I looked on google but generally getting links regarding tuning scripts but I need something on database creation with optimization.

Thanks in advance,
Re: Optimized Database Creation [message #324595 is a reply to message #324586] Tue, 03 June 2008 04:32 Go to previous message
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Check this link


Hope that helps


Previous Topic: Defining Date Format while creation table
Next Topic: How to tuning this query
Goto Forum:

Current Time: Thu Oct 27 23:56:40 CDT 2016

Total time taken to generate the page: 0.08447 seconds