Home » RDBMS Server » Performance Tuning » Sample database for tuning tests
Sample database for tuning tests [message #64808] Mon, 09 February 2004 03:42 Go to next message
Messages: 15
Registered: February 2001
Junior Member

I am looking for a sample database for practicing on tuning. Ideally a script that creates a schema with performance problems (i.e. sql, memory etc tuning)

Help very much appreciated!


Re: Sample database for tuning tests [message #64815 is a reply to message #64808] Wed, 11 February 2004 10:03 Go to previous message
Messages: 50
Registered: January 2004
Hi Christian,
"Perfomance problems" doesn't come that easy, and not as you expect that explainable.
You can create a database, insert 10 mill rows and conclude that indexing would help.
You can experiment with cluster indexes, bitmap indexes, IOT and a lot of other stuff, but experience will not come to you "in the lab"
-Thats life, even when it comes to databases
Previous Topic: local vs dictionary tablespaces
Next Topic: 10 % Hit Ratio
Goto Forum:

Current Time: Sat Feb 24 20:44:00 CST 2024