×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

INFORMIX problems

INFORMIX problems

INFORMIX problems

(OP)
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.


RE: INFORMIX problems

Without the table structure nor the index you've created nor the select instruction it's hard to say anything ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

RE: INFORMIX problems

(OP)
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 about Index?

Thanks.

P.S I use Informix 9.4

RE: INFORMIX problems

Why not posting your table layout and the SQL code of your query ?
How do you expect someone may help you if you say nothing about what you have and what you want ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close