 Related Questions A view is stored procedure based on one or more tables, it’s a virtual table. Latest Answer : View
View is logical table based on one are more table join and named as viewname
View is not stored in database View is used to perform complex query, View Object,
View support, LOB, varray, Nested Tables Should have CREATE ... Cost is basically unit of work or resource used involved memory, I/Oand CPU to execute the query.Card( or Base cardinality) - is the number of rows in a base table captured by running statistics on the Choose - Choose either Rule based or Cost based depend on theavailability of statistics. If statistics is available on the table it usesCBO and if not it uses RBO. ALL_ROWS - Latest Answer : The OPTIMIZER_MODE initialization parameter establishes the default behavior for choosing an optimization approach for the instance.CHOOSEThe optimizer chooses between a cost-based approach and a rule-based approach, depending on whether statistics are ... What is the result ofselect * from table1, table2there is a common column between them but no where caluse has been specified Read Answers (9) | Asked by : sm Write query for the following questions1. sql query for selecting alternate rows in a table2. sql query for deleting alternate rows in a table Read Answers (7) | Asked by : lokesh Latest Answer : what is cursor ?how many type?what is the diffrence ?what is exception?diffrence between function & procedurelike wise you can prepare your own questions. ... Read Answers (1) | Asked by : sameer Latest Answer : We can't select next value and current value from views. ... Read Answers (1) | Asked by : Preeti Explain the differences between cost-based optimizer and Rule-based optimizer ? Why DB2, Sybase is cost based and SQL, Oracle are Rule Based Optimisers ? Read Answers (1) | Asked by : Aruna.G Latest Answer : The purpose of both the commands is different. Then how can you compare insert and delete performane? ... Read Answers (1) | Asked by : Usman There is a table with Pluks('plk') and Zinks ('zin'). Each Pluk onlyresides on a single Zink and each Zink may contain multiple Pluks. Howdo you find how many Pluks are on each and Latest Answer : Dead lock is a unique situation in multiuser system that causes two or more users to wait indefinately for a locked resource. First user needs a resource locked by the second user and second user needs the resource locked by the first user.To avoid ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
