Full table scans

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 6 May 2003 14:33:35 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703A39887@lnewton.leeds.lfs.co.uk>

Afternoon,

don't forget though, a full table scan is not always a bad thing. Sometimes it is better to do one than to lookup an index for a 'large number' of rows.

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Kalle [mailto:kminerva_at_jippii.fi]
Posted At: Tuesday, May 06, 2003 12:21 PM Posted To: server
Conversation: Full table scans
Subject: Full table scans

Hi all,

how I am able to locate the worst possible sql-statements from sga..

Merci Beaucoup...

Kalle Received on Tue May 06 2003 - 08:33:35 CDT