• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 376
  • Last Modified:

Cost is more when selecting all records from table..


 I am just selecting all records from table. but for that itself i am getting cost > 8000.

what could be the reason.
Is this normal?
or I can do something for this?
1 Solution
slightwv (䄆 Netminder) Commented:
Cost is a meaningless number when trying to gauge actual performance.  Many times a higher cost can out perform something with a lower cost.

Selecting ALL records from a table is guaranteed to be a full table scan (FTS)  unless it is index-organized.

The only way to speed up a FTS is faster disks, partitioning, add a where clause to allow index usage.

Depending on the app, maybe artificial paging.  In other words, the app only displays 20 rows at a time then only bring back 20 rows from the database.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now