Difference - Rebuild and Analyze index

Hi, Can anybody please tell me the difference between - SQL execute DBMS_UTILITY.ANALYZE_SCHEMA('BLAH','COMPUTE',NULL,30,'FOR ALL INDEXES'); and SQL select 'ALTER INDEX ' || INDEX_NAME || ' REBUILD ONLINE;' from USER_INDEXES If I execute any one the above do i need to execute the

Re: Difference - Rebuild and Analyze index

index , after that you dont have latest statistics and queries may not perform upto mark . -oramagic Marul Mehta [EMAIL PROTECTED] wrote: Hi, Can anybody please tell me the difference between - SQL execute DBMS_UTILITY.ANALYZE_SCHEMA('BLAH

Optimized solution for large amount of data

)? What should be the database parameters and hardware configuration? We will be using Oracle 8.1.6 on Redhat Linux 6.2 or Suse Linux 7.0. Thanks a lot, Marul. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marul Mehta INET: [EMAIL PROTECTED] Fat City Network

Re: Unix Solaris forum.

') 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marul Mehta INET

Re: Encryption of data

Title: RE: Encryption of data What about encrypting the entire tablespace? has anybody tried this before? Thanks, Marul - Original Message - From: Amar Kumar Padhi To: Multiple recipients of list ORACLE-L Sent: Sunday, August 11, 2002 11:04 AM Subject: RE:

Re: double quotes column name

: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marul Mehta INET: [EMAIL PROTECTED] Fat City Network Services

Function-Based Index not working

Hi, Can you please help me out in solving this weird problem of funcation-based index not being used when I query the table. This is the comand I fired and the result it returned me. 1. SQL create table employees (last_name varchar2(20)); Table created. 2. SQL CREATE INDEX upper_ix ON

Re: Function-Based Index not working

can be fetched in atleast 2 fetches, full table scan will be done instead of INDEX scan, to avoid doubling of work. Naveen -Original Message-From: Marul Mehta [mailto:[EMAIL PROTECTED]]Sent: Saturday, August 31, 2002 2:18 PMTo: Multiple recipients of list ORACLE

Re: Function-Based Index not working

the same query. It should work naveen -Original Message-From: Marul Mehta [mailto:[EMAIL PROTECTED]]Sent: Saturday, August 31, 2002 4:03 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Function-Based Index not working Thanks a lot Naveen

Re: Function-Based Index not working

=FIRST_ROWS; And + can't use IS NULL IS NOT NULL clause. + can't use Like operator. Regards, Marul. - Original Message - From: Marul Mehta To: Multiple recipients of list ORACLE-L Sent: Saturday, August 31, 2002 6:33 PM Subject: Re: Function-Based Index not working

Re: Function-Based Index not working

: Function-Based Index not working I think everythying is fine. Did you try index hint? try that and see. if that also doesn't work, then either we are missing something or the Optimizer thinks so Naveen -Original Message-From: Marul Mehta [mailto:[EMAIL

Disabling indexes - temporarily

Hi all, Need to know if the following is possible in Oracle(any version):- I have a table of around (a) 30 Columns (b) 20 out of 30 are indexed (c) around 1 million (1,000,000) records. Most of the time there will be heavy reads (select queries) on this table except for some 100-400

Re: Disabling indexes - temporarily

-Original Message-From: Marul Mehta [mailto:[EMAIL PROTECTED]]Sent: Saturday, August 31, 2002 11:08 PMTo: Multiple recipients of list ORACLE-LSubject: Disabling indexes - temporarily Hi all, Need to know if the following is possible in Oracle(any version):- I

Re: Disabling indexes - temporarily

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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marul Mehta INET: [EMAIL PROTECTED] Fat City

Inserts are taking time !

Hi All, We have a table which can contain more than half a million records. When we try to insert some 10k records in the empty table it get inserted in 10 min. but as the size increases time taken to insert also increases. After 350,000 records it takes around an hour to insert 10k

Re: Inserts are taking time !

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marul Mehta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Inserts are taking time !

://www.orafaq.com -- Author: Marul Mehta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

Re: Inserts are taking time !

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marul Mehta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Inserts are taking time !

-- Author: Marul Mehta INET: [EMAIL PROTECTED] 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

Re: Inserts are taking time !

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marul Mehta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing