My Table has 15 columns and I can't modify its structure because the application is already done. I created simple Indexes and the result of the query has returned in 30 min. I think the Indexes are the problem but I do not have experience in working with Informix, can someone give me a tip...
I have a huge Table (over 1.000.000 records) and when I make a SELECT, it's take too much time to make it and I don't know how to solve this problem. I created INDEXS but it doesn't work.
Can anyone help me?
Thanks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.