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
Christian
Messages: 15
Registered: February 2001
Junior Member
Hello:

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!

Regards

Christian
Re: Sample database for tuning tests [message #64815 is a reply to message #64808] Wed, 11 February 2004 10:03 Go to previous message
ilver
Messages: 50
Registered: January 2004
Member
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
/ilver
Previous Topic: local vs dictionary tablespaces
Next Topic: 10 % Hit Ratio
Goto Forum:
  


Current Time: Thu Mar 28 09:51:21 CDT 2024