For Indexes you can use :DBA_INDEXESALL_INDEXESUSER_INDEXESFor Constraint you can use :DBA_CONSTRAINTSALL_CONSTRAINTSUSER_CONSTRAINTSFor index upon which table and which column you can query on:DBA_CONS_COLUMNSALL_CONS_COLUMNSUSER_CONS_COLUMNS
There are a number of things you can add to checklist while setting up DBMS and the checklist will depend on which kind of organisation is it. I am assuming you are a DBA setting up DBMS for software ...
It is the property of the database to utilize the additional resources such as the memory and processors to meet the increased demand. By scaling performance is increased to a greater extend
Scalabilty is a database property by means of which the database utilizes the available additional resources such as the memory and the processors to meet the increasing demand.
These answers are probably all correct---if it's SQLServer or Sybase. I don't think the DBMS was identified and for sure the data dictionary/relational catalog/system tables are not standard in naming...
rajnarayan yadav
Jan 16th, 2006
Index information in : user_indexes Constraint information in : user_constraints and user_cons_columns
There are restrictions on indexed views in SQL server such as the columns are not nullable.
Harsh Gupta
Apr 8th, 2006
Hi1) Sql Server 2000 and Oracle does have added the facility of indexed views. Prior to Sql Server 2000 indexed views were not there.2) Oracle call them as Materialized views and Sql Server 2000 call ...
Other than those mentioned above the different indexes are1)ClusteredRequires the date to be sortedwe can create 1 clustered2)Non-Clustereddoesnt require the data to be sortedWe can create 249 non-clustered indexes
Types of IndexesThere are different types of indexes that can be created on tables in a database, all of which serve the same goal?to improve database performance by expediting data retrieval. Indexes...
Perform is purely based on executionhow we get the result, ie Time , spped etcbutexecute is purely depends on logic of how we had done the design and code,itslike the output for given input for a written logic
anand sharma
Sep 8th, 2006
what is the difference between perform and execute?
A Hash index stores key value pairs based on a pseudo randomizing function called hash functionA B+- Tree is a balanced tree whose leaves contain a sequence of key pointer pairs.- Use a hash index for point queries only. Use a B- Tree if multipoint queries or range queries are used.
component based Arc:The database building structure depends upon to the component such as Kernel level.Advantage:The accessing speed will be more than other component.
DBMS includes the theoretical part that how datas are stored in a table. It does not relate tables with another. While RDBMS is the procedural way that includes SQL syntaxes for relating tables with a...
M.Mahesh Kumar
Nov 24th, 2005
RDBMS is enabled nu static 2-dimensional tables. ADBMS is enabled by vector field and is n- dimensional.
SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL) including transaction control, exception and error hand...
in the task bar type (after the QMF returns your query results)-EXPORT REPORT TO filename.txt hit enter and the console will display the complete name of the data set to which your results have been e...
Ans