Answer Posted / nishi
Oracle does not allow a user to specifically locate tables, since that is a part of the function of the RDBMS. However, for the purpose of increasing performance, oracle allows a developer to create a CLUSTER. A CLUSTER provides a means for storing data from different tables together for faster retrieval than if the table placement were left to the RDBMS.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is oracle analytical function?
What happens if recursive calls get out of control?
How to check the oracle tns settings?
How to use like conditions in oracle?
What is the quickest way to export a table to a flat file?
What is primefaces used for?
What is recycle bin in Oracle?
Is there a function to split a string in plsql?
How remove data files before opening a database?
How to do a full database export?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What are joins, explain all types of joins?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How to load data from external tables to regular tables?
