Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 374
  • Last Modified:

Cost is more when selecting all records from table..

Hi,

 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?
0
sakthikumar
Asked:
sakthikumar
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.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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