See
the table's size is very small. Till it atleast 2 times the value of
DB_BLOCK_SIZE * DB_FILE_MULTIBLOCK_READ_COUNT it will not use
index.
Set
the value of DB_FILE_MULTIBLOCK_READ_COUNT to one.
Insert lots of values in the
table. You can make a procedure to insert random characters into the table, and
then put it in a big loop. Analyze table and thn run the same
query.
It should work
naveen
-----Original Message----- From: Marul Mehta [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 31, 2002 4:03 PM To: Multiple recipients of list ORACLE-L Subject: Re: Function-Based Index not working
|
- Function-Based Index not working Marul Mehta
- RE: Function-Based Index not working Naveen Nahata
- RE: Function-Based Index not working Sandeep Kurliye
- Re: Function-Based Index not working Marul Mehta
- Re: Function-Based Index not working Naveen Nahata
- Re: Function-Based Index not working Marul Mehta
- RE: Function-Based Index not working Seefelt, Beth
- RE: Function-Based Index not working Naveen Nahata
- Re: Function-Based Index not working Marul Mehta
- Re: Function-Based Index not working Marul Mehta
- Re: Function-Based Index not working Steve Perry
- Re: Function-Based Index not working Steve Perry
- RE: Function-Based Index not working Andrey Bronfin
- Re: Function-Based Index not working Jared Still
- RE: Function-Based Index not working Jamadagni, Rajendra