Varray Problem
Hi there ... I have a table with a Varray Columns. When I used a select operation without access the varray columns the explain plan show fine.. cost = 4 but when I access the Varray columns then I got the cost = 1310 Why ? What happend ? and why oracle did it ? Someone can explain it to me ? or how shoud I optimized it ? this is my query without varrary SELECT a.id, a.address FROM my_table a OperationObject NameRowsBytesCost SELECT STATEMENT Hint=CHOOSE3 4 SORT GROUP BY3 60 4 TABLE ACCESS FULLMY_TABLE9 180 2 this is my query with varrary SELECT a.id, a.address FROM my_table a, TABLE(a.no_of_car) b Operation Object NameRowsBytesCost SELECT STATEMENT Hint=CHOOSE3 1310 SORT GROUP BY3 459 1310 NESTED LOOPS73 K10 M101 TABLE ACCESS FULLMY_TABLE9 1 K2 COLLECTION ITERATOR PICKLER FETCH regards kang bedjo
IOT Table on a USERS Tablespace
Hi all I will change some of my table into IOT Table My Question : Is it ok to store my IOT Table into Users Tablespace or shoud I store in a new tablespace ..just to hold all IOT Table ? regards kang bedjo -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: B3D70 INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Constraints
hi roland ... it seems your table already had a data redundant data ...for a BUTIKS_NR column and when you try to add a new constraints it produced an error message try to remove redundant data ... or empty your table first... then add a constraint ... regards kang bedjo I'd rather see the world from another angle *- Jewel- * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: B3D70 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, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).