Cost is more when selecting all records from table..

sakthikumar
sakthikumar used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial