Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Tunning using Indexes
I think I used it in 8.0.3 first, but haven't checked all the intermediate versions.
-- Jonathan Lewis Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk Practical Oracle 8i: Building Efficient Databases Publishers: Addison-Wesley Book bound date: 8th Dec 2000 See a first review at: http://www.ixora.com.au/resources/index.htm#practical_8i More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html Nuno Souto wrote in message <3a1fa576.887248_at_news-server>...Received on Sat Nov 25 2000 - 06:53:13 CST
>On Fri, 24 Nov 2000 20:57:21 -0000, "Jonathan Lewis"
><jonathan_at_jlcomp.demon.co.uk> wrote:
>
>>
>>It's certainly an option to consider.
>>In fact it's always worth considering having
>>different degrees of parallelism on the index
>>and the table when using partitioned tables.
>>There may be cases where (for example)
>>a parallel degree 10 scan of a table and a
>>parallel degree 5 index range scan perform
>>at about the same speed, but one is more
>>desirable than the other for some application
>>dependent reason.
>>
>
>Jonathan,
>
>Parallel index range scan is only available in 8i, isn't it? I don't
>think it can be done by hint on 8.0.
>Please correct me if I'm wrong.
>I've got a partitioned table and local index that could benefit from
>parallel index range scan, but I'm stuck on 8.0... (third party s/w!)
>
>TIA
>
>Cheers
>Nuno Souto
>nsouto_at_bigpond.net.au.nospam
>http://www.users.bigpond.net.au/the_Den/index.html