Give the reasoning behind using an index.

Give the reasoning behind using an index.
by

1 Answer

Answer :

Faster access to data blocks in a table.
by

Related questions

Why is Oracle not using the damn index? (for DBA

Description : Why is Oracle not using the damn index? (for DBA

Last Answer : This problem normally only arises when the query plan is being generated by the Cost Based Optimizer. The usual cause is because the CBO calculates that executing a Full Table Scan would be faster ... with AUTOTRACE to see the statistics. Compare this to the explain plan when not using an index.

What is the reasoning behind this logic question?

Description : What is the reasoning behind this logic question?

Last Answer : if housing starts are down, merrihew lumber does not necessarily go out of business. the question only states explicitly, that ML will not have to declare bankruptcy if housing projects are up. it does ... is unknown and it can not be determined whether or not they will phase out their masonry line.

What is the reasoning behind gambling being illegal on US soil?

Description : What is the reasoning behind gambling being illegal on US soil?

Last Answer : The government doesn’t collect its cut from illegal gambling, but makes serious bank on lotteries and approved casinos and such.

What's the reasoning behind shoelace length?

Description : What's the reasoning behind shoelace length?

Last Answer : I think it has to do with ethics aesthetics. The dress shoes would look ridiculous with a big, fat bow. Granted, it can be a little hassle tying them (the short laces in the dress shoes), but it looks slick. Why the sneakers come with 100 feet, i have not an idea. Edited: Thanks @Fyrius !

What is the evolutionary reasoning behind a mosquito's buzz?

Description : What is the evolutionary reasoning behind a mosquito's buzz?

Last Answer : Ok, I'm going to have to go do some research but I'm pretty sure that only the females buzz (and only the females bite). Maybe a method for finding mates? Some trivia: http:// ... /blog/2007/07/05/why-mosquitoes-buzz-in-peoples-ears/ http://www.sciencenewsforkids.org/articles/20040811/Feature1.asp

If you believe in satan, ghosts or demons but don’t believe in god will you say your reasoning behind why?

Description : If you believe in satan, ghosts or demons but don’t believe in god will you say your reasoning behind why?

Last Answer : I don't believe in Satan or demons, but do ghosts, I've had several occurrences that can't be explained otherwise, and God there's no evidence just as Satan and demons, and if there is why do ... people with their interpretations. I don't believe in something I can't see or experience, explain....

If you believe in satan, ghosts or demons but don’t believe in god will you say your reasoning behind why?

Description : If you believe in satan, ghosts or demons but don’t believe in god will you say your reasoning behind why?

Last Answer : I don't believe in Satan or demons, but do ghosts, I've had several occurrences that can't be explained otherwise, and God there's no evidence just as Satan and demons, and if there is why do ... people with their interpretations. I don't believe in something I can't see or experience, explain....

What is the reasoning behind forcing people to pay taxes in a free market economy?

Description : What is the reasoning behind forcing people to pay taxes in a free market economy?

Last Answer : To provide revenues for government programs needed to protect the free market. -apex

How can you rebuild an index?

Description : How can you rebuild an index?

Last Answer : ALTER INDEX REBUILD;

What type of index should you use on a fact table?

Description : What type of index should you use on a fact table?

Last Answer : A Bitmap index.

What is an index segment?

Description : What is an index segment?

Last Answer : Each index has an index segment that stores all of its data.

What is index cluster?

Description : What is index cluster?

Last Answer : A cluster with an index on the cluster key.

what is clustered index?

Description : what is clustered index?

Last Answer : In an indexed cluster, rows are stored together based on their cluster key values . Can not applied for HASH.

When should one rebuild an index? (for DBA

Description : When should one rebuild an index? (for DBA

Last Answer : You can run the 'ANALYZE INDEX VALIDATE STRUCTURE' command on the affected indexes - each invocation of this command creates a single row in the INDEX_STATS view. This row is overwritten by the next ANALYZE ... 'badness' of the index can then be judged by the ratio of 'DEL_LF_ROWS' to 'LF_ROWS'.

What is an Index ? How it is implemented in Oracle Database ?

Description : What is an Index ? How it is implemented in Oracle Database ?

Last Answer : An index is a database structure used by the server to have direct access of a row in a table. An index is automatically created when a unique of primary key constraint clause is specified in create table comman (Ver 7.0)

What is Index Cluster ?

Description : What is Index Cluster ?

Last Answer : A Cluster with an index on the Cluster Key

How are the index updates?

Description : How are the index updates?

Last Answer : Indexes are automatically maintained and used by Oracle. Changes to table data are automatically incorporated into all relevant indexes.

What is an Oracle index?

Description : What is an Oracle index?

Last Answer : An index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table.

What is an Index ?

Description : What is an Index ?

Last Answer : An Index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table.

What is an Index Segment ?

Description : What is an Index Segment ?

Last Answer : Each Index has an Index segment that stores all of its data.

What is a Global Index and Local Index?

Description : What is a Global Index and Local Index?

Last Answer : Local Index - each partition of a local index is associated with exactly one partition of the table. Global Index - global index is associated with multiple partitions of the table. ... - Global Hash Partitioned Indexes Global Nonpartitioned Indexes - behave just like a nonpartitioned index.

What is an Index Organized Table?

Description : What is an Index Organized Table?

Last Answer : An index-organized table (IOT) is a type of table that stores data in a B*Tree index structure. Normal relational tables, called heap-organized tables, store rows in any order (unsorted). In contrast ... all the columns of the table (an exception to this rule - is being called the overflow area).

A Column is having many repeated values which type of index you should create on this column, if you have to?

Description : A Column is having many repeated values which type of index you should create on this column, if you have to?

Last Answer : For example, assume there is a motor vehicle database with numerous low-cardinality columns such as car_color, car_make, car_model, and car_year. Each column contains less than 100 distinct values by themselves, and a b tree index would be fairly useless in a database of 20 million vehicles.

What is B-Tree Index?

Description : What is B-Tree Index?

Last Answer : A B-Tree index is a data structure in the form of a tree, but it is a tree of database blocks, not rows. Note: "B" is not for binary; it's balanced.

How does one backup a database using the export utility? (for DBA

Description : How does one backup a database using the export utility? (for DBA

Last Answer : Oracle exports are "logical" database backups (not physical) as they extract data and logical definitions from the database into a file. Other backup strategies normally back-up the physical data ... exports include more information about the database in the export file than user level exports.

How you will avoid your query from using indexes?

Description : How you will avoid your query from using indexes?

Last Answer : SELECT * FROM emp Where emp_no+' '=12345; i.e you have to concatenate the column name with space within codes in the where condition. SELECT /*+ FULL(a) */ ename, emp_no from emp where emp_no=1234; i.e using HINTS

What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?

Description : What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?

Last Answer : 1,000,00

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

Description : What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

Last Answer : % TYPE provides the data type of a variable or a database column to that variable. % ROWTYPE provides the record type that represents a entire row of a table or view or columns selected in ... database definition of a column in a table changes, the data type of a variable changes accordingly.

How does one backup a database using RMAN? (for DBA

Description : How does one backup a database using RMAN? (for DBA

Last Answer : The biggest advantage of RMAN is that it only backup used space in the database. Rman doesn't put tablespaces in backup mode, saving on redo generation overhead. RMAN will re-read database ... directly to tape. Alternatively one can backup to disk and then manually copy the backups to tape.

How will you enforce security using stored procedures?

Description : How will you enforce security using stored procedures?

Last Answer : Don't grant user access directly to tables within the application. Instead grant the ability to access the procedures that access the tables. When procedure executed it will execute the privilege of procedures owner. Users cannot access tables except via the procedure.

How can one see who is using a temporary segment? (for DBA

Description : How can one see who is using a temporary segment? (for DBA

Last Answer : For every user using temporary space, there is an entry in SYS.V$_LOCK with type 'TS'. All temporary segments are named 'ffff.bbbb' where 'ffff' is the file it is in and 'bbbb' is ... For usage stats, see SYS.V_$SORT_SEGMENT From Oracle 8.0, one can just query SYS.v$sort_usage. Look at these

How will you enforce security using stored procedures?

Description : How will you enforce security using stored procedures?

Last Answer : Don't grant user access directly to tables within the application. Instead grant the ability to access the procedures that access the tables. When procedure executed it will execute the privilege of procedures owner. Users cannot access tables except via the procedure.

What is Enterprise Structure Configurator (ESC) and what are the benefits of using it?

Description : What is Enterprise Structure Configurator (ESC) and what are the benefits of using it?

Last Answer : The ESC is an interview-based tool that guides you through the configuration of your enterprise structures. Use the ESC as part of your set up to define the organization structures and job and position structures of the enterprise.

What are stored-procedures? And what are the advantages of using them.

Description : What are stored-procedures? And what are the advantages of using them.

Last Answer : Stored procedures are database objects that perform a user defined operation. A stored procedure can have a set of compound SQL statements. A stored procedure executes the SQL commands and returns the result to the client. Stored procedures are used to reduce network traffic.

How does one give developers access to trace files (required as input to tkprof)? (for DBA)

Description : How does one give developers access to trace files (required as input to tkprof)? (for DBA)

Last Answer : The "alter session set sql_trace=true" command generates trace files in USER_DUMP_DEST that can be used by developers as input to tkprof. On Unix the default file mask for these files are "rwx r-- -- ... = true Include this in your INIT.ORA file and bounce your database for it to take effect.

Give two methods you could use to determine what DDL changes have been made.

Description : Give two methods you could use to determine what DDL changes have been made.

Last Answer : You could use Logminer or Streams

Give the stages of instance startup to a usable state where normal users may access it.

Description : Give the stages of instance startup to a usable state where normal users may access it.

Last Answer : STARTUP NOMOUNT - Instance startup STARTUP MOUNT - The database is mounted STARTUP OPEN - The database is opened

Give two examples of referential integrity constraints.

Description : Give two examples of referential integrity constraints.

Last Answer : rential integrity constraints.

Give the two types of tables involved in producing a star schema and the type of data they hold.

Description : Give the two types of tables involved in producing a star schema and the type of data they hold.

Last Answer : Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

Give two examples of how you might determine the structure of the table DEPT.

Description : Give two examples of how you might determine the structure of the table DEPT.

Last Answer : Use the describe command or use the dbms_metadata.get_ddl package.

Give the structure of the function ?

Description : Give the structure of the function ?

Last Answer : FUNCTION name (argument list .....) Return datatype is local variable declarations Begin executable statements Exception execution handlers End;

Give the structure of the procedure ?

Description : Give the structure of the procedure ?

Last Answer : PROCEDURE name (parameter list.....) is local variable declarations BEGIN Executable statements. Exception. exception handlers end;

Give built-in routine related to a record groups?

Description : Give built-in routine related to a record groups?

Last Answer : Create_group (Function) Create_group_from_query(Function) Delete_group(Procedure) Add_group_column(Function) Add_group_row(Procedure) Delete_group_row(Procedure) Populate_group(Function) Populate_group_with_query(Function) Set_group_Char_cell(procedure)

Give the Types of modules in a form?

Description : Give the Types of modules in a form?

Last Answer : Form Menu Library

Give the equivalent term in forms 4.0 for the following. Page, Page 0?

Description : Give the equivalent term in forms 4.0 for the following. Page, Page 0?

Last Answer : Page - Canvas-View Page 0 - Canvas-view null.

Can you attach an lov to a field at run-time? if yes, give the build-in name.?

Description : Can you attach an lov to a field at run-time? if yes, give the build-in name.?

Last Answer : Yes. Set_item_proprety

Name the two files that are created when you generate the form give the filex extension ?

Description : Name the two files that are created when you generate the form give the filex extension ?

Last Answer : INP (Source File) FRM (Executable File)

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Description : Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Last Answer : a. ON-INSERT b. POST-INSERT c. PRE-INSERT

Give the sequence of execution of the various report triggers?

Description : Give the sequence of execution of the various report triggers?

Last Answer : Before form , After form , Before report, Between page, After report.

How can a button be used in a report to give a drill down facility?

Description : How can a button be used in a report to give a drill down facility?

Last Answer : By setting the action associated with button to Execute pl/sql option and using the SRW.Run_report function.