Create a new index
Posted: Thu Oct 07, 2010 4:06 pm
Hello,
I have a question please. What is the criteria to create a new index on a db2 table ?
I will have to access to a db2 table using a field that is not key. It is not indexed on.
I'd want to know how I could determinate if I must to create a new index or not to improve the performance for reading.
Thanks in advance !!!
I have a question please. What is the criteria to create a new index on a db2 table ?
I will have to access to a db2 table using a field that is not key. It is not indexed on.
I'd want to know how I could determinate if I must to create a new index or not to improve the performance for reading.
Thanks in advance !!!