| Sample database for tuning tests [message #64808] |
Mon, 09 February 2004 03:42  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
