Indexing strategy needed to increase DB performance

Arnielover · #1 (**permalink**) 01-12-04, 10:47

Hi i have a basic project management database and i need to create indexes to increase peformance. I know how to create indexes but im not sure what tables i need to index. What info do you need to help me?

andrewst · #2 (**permalink**) 01-12-04, 11:07

It's more a case what what information you need to help yourself

What DBMS are you using for a start?

Arnielover · #3 (**permalink**) 01-12-04, 11:17

im using Oracle 9i, if thats any help, i only know the basics of indexing, this is for a uni assignment so its not an actual working database.

andrewst · #4 (**permalink**) 01-12-04, 11:21

I have responded to your similar post in the Oracle area.

Internet Services

Web Development

Digital Marketing

Consumer Tech