Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: performace question...
Hello Vince,
"Vince Laurent" <eAddict_at_yahoo.com> wrote in message
news:d4vn705otlrjv6li6g0ku9h1uteamse0og_at_4ax.com...
> Quick question: Are full table scans bad for performance? I am
> guessing yes. I ran this script:
>
I wonder why think "full table scans [are] bad for performance". An FTS is just a way to access data. It may be that due to the nature of your application, this is the most efficient way(or not). You need to analyze the application itself (design, SQL queries, etc.) before making any conclusions as to whether some metric is 'good' or 'bad'. The number you've presented is quite meaningless without a context.
VC Received on Tue Apr 13 2004 - 11:21:01 CDT