Answer Posted / rajesh naidu
INDEX IS USED TO IMPROVE THE PERFORMANCE OF THE DATABASE AND
ALSO IT IS USE FULL FOR FASTER FETCHING THE REQUIRED DATA
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
how to restore files with rman?
How would you best determine why your MVIEW couldn't FAST REFRESH?
What purpose does the model database server? : sql server DBA
what are the benefits of flashback feature?
What are the recovery models for a database? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
Query processing is slow(eg select query)how will u solve that
What are the different types of database compression introduced in sql server 2008? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?