Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ehtesham malik
Alter index index_name REBUILD COPMUTE STATISTICS
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Why does Oracle not permit the use of PCTUSED with indexes?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What is replication? : sql server DBA
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.
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
how can you communicate with operating system files from oracle?
Where would you look for errors from the database engine?
what is the use of ocr?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Can you redefine a table online?
