RE: A question about performance

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_000_01BFDBC8.CDAD9CB4
Content-Type: text/plain;
 charset=iso-8859-1
Content-Transfer-Encoding: 7bit

Re-read the reply.

It does make a difference.

George.

> -----Original Message-----
> From: "Singla, Sanjeev" <SSingla_at_oxhp.com> [mailto:SSingla_at_oxhp.com]
> Sent: Wednesday, June 21, 2000 5:50 PM
> To: SMTP_at_INL002@Servers["Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>]
> Subject: RE: A question about performance
>
>
> Distribution of data does not make any difference because he
> is scanning the
> entire table,
> so it has to scan all the blocks anyway.
> So in this table full scan will be better.
>
>
> -----Original Message-----
> [mailto:George.Brennan_at_warnermusic.com]
> Sent: Wednesday, June 21, 2000 11:48 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Why is everyone jumping to conclusions about the data?
>
> What is the distribution of the values in the table?
> How many rows per data block?
> etc.
>
> If there are > 10% ( or so ) with a value >= 0 then the index
> may be faster.
> If there are > 10% ( or so ) with a value <= 0 then the index
> may be slower.
>
> e.g. a PK col + long col may only be 1 row per block that may
> screw you
> ideas up a bit. :-)
>
> George
>
> > -----Original Message-----
> > From: "Singla, Sanjeev" <SSingla_at_oxhp.com> [mailto:SSingla_at_oxhp.com]
> > Sent: Wednesday, June 21, 2000 3:30 PM
> > To: SMTP_at_INL002@Servers["Multiple recipients of list ORACLE-L"
> > <ORACLE-L_at_fatcity.com>]
> > Subject: RE: A question about performance
> >
> >
> > Full table scan will be faster.
> > Reason: If it go for index scan it will get the rowids
> > and come back
> > with those
> > rowids to scan the table because u are selecting all the
> > columns so it has
> > to do full
> > scan of table also for getting everything.
> > Index scan + full scan of table for actual data. (If going
> > for index scan)
> > ----------- Only table scan for actual blocks (Full scan)
> >
> > Cheers.
> >
> > -----Original Message-----
> > Sent: Tuesday, June 20, 2000 11:35 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi All:
> > There is a question about performance.
> > Table name : subscriber , primary key :
> > subscr_id , with
> > over 5000000 records .
> >
> > CASE 1 : select *
> > from subscriber ;
> > (FULL TABLE SCAN)
> >
> > CASE 2 : select *
> > from subscriber
> > where subscr_id > 0 ;
> > (USE INDEX)
> >
> > Could anyone tell me which ones performance is
> > better , or
> > they are the same ??
> >
> > Thank you in advance.
> >
> >
> > Tiffany
> > E-mail tiffanydu_at_pcdc.com.tw
> >
> >
> > --
> > Author: =?big5?B?VGlmZmFueSBEdSAoIKf5p0qq4iAp?=
> > INET: TiffanyDu_at_pcdc.com.tw
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access /
> Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Author: Singla, Sanjeev
> > INET: SSingla_at_oxhp.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access /
> Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> >
>
>
> --
> Author:
> INET: George.Brennan_at_warnermusic.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Author: Singla, Sanjeev
> INET: SSingla_at_oxhp.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

------_=_NextPart_000_01BFDBC8.CDAD9CB4
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

eJ8+IjIVAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQWAAwAOAAAA0AcGABUAEQArAAkAAwA6AQEggAMADgAAANAHBgAV ABYAJAAwAAMAXwEBCYABACEAAABCQjlCMUMwNTg3NDdENDExQTVGNjAwRDBCNzQ3MzBEQwAgBwEE gAEAIQAAAFJFOiBBIHF1ZXN0aW9uIGFib3V0IHBlcmZvcm1hbmNlALcLAQ2ABAACAAAAAgACAAED kAYA7A4AAC8AAAADAAeACCAGAAAAAADAAAAAAAAARgAAAABShQAAJ2oBAB4ACIAIIAYAAAAAAMAA AAAAAABGAAAAAFSFAAABAAAABAAAADkuMAALAAyACCAGAAAAAADAAAAAAAAARgAAAAAGhQAAAAAA AAMAAYAIIAYAAAAAAMAAAAAAAABGAAAAAAGFAAAAAAAACwAEgAggBgAAAAAAwAAAAAAAAEYAAAAA A4UAAAAAAAALAAKACCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAAMABYAIIAYAAAAAAMAAAAAA AABGAAAAABCFAAAAAAAAAwADgAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAADAACACCAGAAAA AADAAAAAAAAARgAAAAAYhQAAAAAAAB4ACYAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAA AAAAAAAeAAqACCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgALgAggBgAAAAAA wAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAAIBCRABAAAA0AgAAMwIAADLGAAATFpGdcN8t0sD AAoAcmNwZzEyNeIyA0N0ZXgFQQEDAff/CoACpAPkBxMCgA/zAFAEVj8IVQeyESUOUQMBAgBjaOEK wHNldDIGAAbDESX2MwRGE7cwEiwRMwjvCfe2OxgfDjA1ESIMYGMAUHMLCQFkMzYWUAumB/BlAi0Y IGFkIHRoZeYgGCALUHkuCqIKhAqAskkFQGRvB5EAwGsdkDZhHvAGkGYEkAnwY2WmLgrjHlZHZQWw ZyBQUR4aPiAtIpJPBRBnzwuAB0AF0AeQc2EhgCKThSIWRgNhOiAiUwuAKmcLYCwGAmoJ4HYiCCA8 UyUkQG94aNRwLgWgbSJwWwDAAxDodG86Jk5dIhYGYAIwFSTwVwmAbgeQZGF5iSWASnUqACAyMSWA QwHQKyAgNTo1FlBQGk0iFlQnwAYATVRQkEBJTkwrIDJABmGCdgSQc1siTXUnoPUFIGwdkmMFIAiQ AjAEIDBvZiBsBAAFQE9SgEFDTEUtTCIiFkI8L6ZAZmF0LpB0px3wJxIo6HViJdBjKaHEUkUk8EEg cQpQL3CuaQIgH5AG4HUFQHAEkL0CEHIDgSBAIhY1PkQvYf0FEGI0UDPiLyEqMAGQHvRMbm8FQB9U bnkfuSDSYgWQYXUUECAdgSIW/QQAIATwAHADACVAHWIiFr0pgWkYIB1gAaAuQCwiFvxzbzrwBUAT 4AQgJ7A7Ix0fkGwDIB1yAmBvY2v7BCA44XcqQB4FKVE90QOg5x1wOwE84yBmLfADID6T/wPwPvE5 0DnBAkAEkEA3Q25vIp8jrydmIUVCIBFFgG7uQEAABKAEkG06EA3gKK+DKb8qyDExOjQ4EMA/K8st 7y7/MABDb0R1V2hvOQA7ASXwBJB5AiAdkGr8dW1N8DuSPdAFoCAwCkC/AJACID+xNDMdcjeyP0/v vxPgBUBBQlPCNs0dcnYHQM8zoUDkPMVUN0hvB+ADgfs5AANgdwQgNIE3pD9jVDf3FCBJEE9uSVbj PLEKwB2QwUTAMTAlIChOUAXAfT3BKUJhHXAfkVdDXVA9viAWUB1xV8QLgAEAeE/X/wDAOQBCwTFQ L3BDOVyfXa+tXrY8X09gX3MXsHdDP5k8US5nIGAfoFBLUoH9AyArL0ACIDugaTJg8gIg+x3gQrIx WYJZ0z9jHWFVYf9g8j1HBQAH0VGQDHA6lgEAaT4xdXAfkWIxkCBgOvwtKU9uIURPbkTPRd9xcn8k vyXPJt8n73EYSf8qjDP8OjMrmiw/LU9Nny9vcVT/ML8xzDKPM580r3D6cRhz4P9B4kF0QithbYax HPA+MAIg73QwifFiUT3xZz3QNLFlxf8+kz3xQnMhgFOUWZFuAAQhv3EnAHAdUHZRObEA0GtxGPte Yx1wbzohhjmMtT5mV+f9Ocd1YtMUEH3AgrA7gj7m/3EYF5FR8AYxPcdxGD5hHwD/QcSGOT6TVtJB gwdAPcGKwn+MMZNTUVNBIXSAIGCGKkk/ixhpcEHYmCeKwgDQdHX3cmE3spphKGJRipA7gnEYv4rM byeGsXGzoUSGwE9qcu+HOZ1JP2WJ8SiG46BNhjn+Qx2AfRGIyXEfci9zOnjUllSDYXmZMEt4MzV7 D399b35/T0iFf7AUAZFY8GnbEMA+8DqxDbGjVGKTOwF/H6CDX4RnpsqzGEGDOEBhe44hdDBzgnAE 8jnQBcAg3XTAcAUQAMBRgCAfcDkA93Qwp3i4JF9uALjRXmKneP5vfQErUCshKyKuEQWwjPHDps+y zENBU0Vq0bgB+ZMTICq+H8E/sdADUrgajxkwwJ/En6RgVUxMe8DcQUIv4AYAv2BOpQ++j/+/kBRA v9/EL8H/uCjKD83v/0JgYpO6iKfwFlDDv9FfxdHGVb+BfGBERVjG/8gN/QhgbB1QOOFRog6wPvGO If/PUA3gXpBRoVnDNLY68qd4/0L0uNEFsJXZHYA5AGLiHXL7qSCOIT9UN9QPs1UAcGvA/21RQOId QFdAtc/Rz7ME25//e7Ef0Tjhp3gv8HayhsCtsIHiQ2R1QHBjZEkTfC50B+Dg798sp4mnaUFLhBCP kHJ0MD0/brBnADU/Qj9WR2xtBFpthuBlU0JFZABTQW9JS2Y1cAAwcXE0aUFwP2Y9hjnTEUVUqpHi NETv5DvlH3PCVWFDgTEHseTgfwWwa8B80g3gB5GJ8aHRKAg4NTheQDUzOC3NK4A1auBz4EFYdDDx DLd4OQORNrBlipB0wEMHQL8GkAWwAwAfoPUlodFQgnD9ftBjmzFDIXlgBUAA0PBhtQQgL0/XTXbB O4JMfuH/lcmhSfn/+w/8H6FEezqC4bhNT1a/kG1RFAFsfrD/wrNBI+NSO4J+0nTAFBCN0f8DkS/w 9+LWcakTldp0MPhi/kcIcOQwgPljcDhRHZDTUH0vwFQ7IIRAPvA7gn6hJ30DJideQI3CC4HZugHG IPBCT0RZdMDeAFLBDxD/H5H4ER2QUpEMkN4AdHF0MGBVTlNVQq8/p/Ao/6MhHXK3s36hAArds0AA qnB/PlJCwRggFWB9AB1QwrIp/ZphWd3RYPGNKZjCAOMdcvBIRUxQjfLXwQ8hoyHfOGBikUDhNLO0 kyh+0B9x/7gmdHEPgOb/6Ax0betfqkD/dZ3tz+7f7+/w//IP8x/0L//1P/ZP91/4byW/Js8n3/yv //2//s//3wDvAf8DDwQfBS//Bj8HTwhfCW8KfwuPDJ8Nr/8Ovw/PEN8R7xL/FA8aH0HZ/0KuFbno Zhf26/ZHj0ibQq7/G18cbx1/Ho8YBSAvIT8iT/8jVCQ/Q+RS31PvVP8o/xgU/yqPK58sry2/GCMv PzBPMV//Mm9bpjQfNS82PzdNOF85b/86fzuPGAU9Lz4/P09AX0Ov/xZvF34YnxmtSL9Jz0rfS+// TP9OD08fUC9RP1JPfZ9+r/9/v1aPV59Yr1m/Ws9b31zv/13/Xw9gH2EvYj9jT2RfZW//Zn9nj2if aa9qv2vPbN9CrwUYA32ZoB4AcAABAAAAHQAAAEEgcXVlc3Rpb24gYWJvdXQgcGVyZm9ybWFuY2UA AAAAAgFxAAEAAAAWAAAAAb/boJ0oCyTUU82kSsiq79tCqsUAiQAAAwAuAAAAAAALAAIAAQAAAAIB MQABAAAAMwEAAFBDREZFQjA5AAEAAgCBAAAAAAAAADihuxAF5RAaobsIACsqVsIAAEVNU01EQi5E TEwAAAAAAAAAABtV+iCqZhHNm8gAqgAvxFoMAAAAV01JQkFLRVJTVDAxAC9vPVRXSS9vdT1XTUdX TUlCQUtFUlNUL2NuPVJlY2lwaWVudHMvY249R2VvcmdlLkJyZW5uYW4ALgAAAAAAAACG+CIZUg3U EaXnANC3RzDcAQBFtUHdRQ3UEaXlANC3RzDcAAAAAQ0yAAAAAAAALgAAAAAAAACG+CIZUg3UEaXn ANC3RzDcAQBFtUHdRQ3UEaXlANC3RzDcAAAAAQ0zAAAQAAAAu5scBYdH1BGl9gDQt0cw3CEAAABS RTogQSBxdWVzdGlvbiBhYm91dCBwZXJmb3JtYW5jZQAAAwAJWQEAAAAeAEIQAQAAADYAAAA8NDVC NTQxREQ0NTBERDQxMUE1RTUwMEQwQjc0NzMwREM5QzQxOERAV01JQkFLRVJTVDAxPgAAAAMA3j+v bwAAQAA5ACCacsif278BAwDxPwkEAAAeADFAAQAAAA8AAABHRU9SR0UuQlJFTk5BTgAAAwAaQAAA AAAeADBAAQAAAA8AAABHRU9SR0UuQlJFTk5BTgAAAwAZQAAAAAADAP0/5AQAAAMAJgAAAAAAAwA2 AAAAAAADAIAQ/////wIBRwABAAAAMwAAAGM9R0I7YT1NQ0k7cD1UV0k7bD1XTUlCQUtFUlNUMDEt MDAwNjIxMTY0MzA5Wi05ODczAAAeADhAAQAAAA8AAABHRU9SR0UuQlJFTk5BTgAAHgA5QAEAAAAP AAAAR0VPUkdFLkJSRU5OQU4AAEAABzCeUVHIn9u/AUAACDC0nK3NyNu/AR4APQABAAAABQAAAFJF OiAAAAAAHgAdDgEAAAAdAAAAQSBxdWVzdGlvbiBhYm91dCBwZXJmb3JtYW5jZQAAAAAeADUQAQAA ADYAAAA8NDVCNTQxREQ0NTBERDQxMUE1RTUwMEQwQjc0NzMwREM5QTU5RkVAV01JQkFLRVJTVDAx PgAAAAsAKQAAAAAACwAjAAEAAAADAAYQRMV2IAMABxCwDgAAAwAQEAAAAAADABEQAwAAAB4ACBAB AAAAZQAAAFJFLVJFQURUSEVSRVBMWUlURE9FU01BS0VBRElGRkVSRU5DRUdFT1JHRS0tLS0tT1JJ Received on Wed Jun 21 2000 - 11:43:09 CDT