Skip_unusable_indexes in 10g - oracle-l - FreeLists

Skip_unusable_indexes in 10g

From: gparc@xxxxxxx
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 17 Jul 2006 17:58:25 +0200

Hi listers,

FYI, skip_unusable_indexes is now a pfile/spfile parameter in 10g
(not only alter session based as in 8i/9i) and defaults to ... TRUE.

I would prefer FALSE as a better default value.

HTH

Regards

Gilles

--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- Re: Skip_unusable_indexes in 10g
  - From: David Sharples
- Re: Skip_unusable_indexes in 10g
  - From: Niall Litchfield
- Re: Skip_unusable_indexes in 10g
  - From: Mladen Gogala

Other related posts: