How to create oracle database for fast operations?

Question

give detail instruction on how to create oracle 9i database on windows server 2003 , so that users can use data speedily.

Answer 1

Your Windows server must have enough RAM and disk space.

For fast operation, your database table must have index for unique fields. Eg. If user query by input date. You must set index for Input date.

Put related data into one table instead of two/more tables so that users do not need to do a join to query the data. Joining tables in SQL will take more time to query.

If not necessary, don't use "order by". The sorting of data will slow down everything if the query data quantity is huge.

Move obsolete data into backup so that the number of data in database will be lesser and query/search for data will be easier and faster.

Answer 2

Hire an expert, there are so many factors that affects the overall performance of an Oracle DB, you will be foolish to just read answers from Yahoo answers!