Database Administrator

Indexes are the main means to accelerate table content access, especially for queries involving connections to multiple tables. This is an important part of database optimization. We need to understand why indexes are needed, how indexes work, and

BKJIA quick translation: what is the use of random row extraction from database tables? Because sometimes you want to present random information to users. The following describes how to extract random row code from several popular databases. BKJIA

When reading the MongoDB GFS document, I learned how to store physical files, including large files. In order to deepen your impression, I wrote an example of uploading files to Mongodb. Of course, since it is stored in the document database, you

Because the development project is based on the project developed by a third-party company, the database is directly dependent, and the relationship between the project source code developed by the company and the database table is unknown, the

The process is like this! Add A record to Table A of the database. ** in the system, there will be 5 N more files under directory B. As the system has been running for more than three years, the number of files in directory B has reached more than 2

I. background DB2 joint database is a special form of distributed database management. In the federated database system, you can use an SQL command to send command requests to multiple data sources. Before copying data between DB2 and non-DB2

Greg Robidoux, a Microsoft SQL Server security expert, is also the chairman of the SQL Server database administrator Special Interest Group PASS DBA SIG. "It usually takes time to make the application run, and security issues are not even discussed,"

This article is a set of effective systems summarized by the author in years of ORACLE Database management work. It greatly improves the work efficiency, so as to predict the potential risks of the database in advance and eliminate them as soon as

Introduction Both DBAs and developers like indexing. They can accelerate query and search, especially in a data warehouse environment, because the database will receive many ad-hoc requests. To avoid full table search, we usually create an index in

The Flash query function introduced by Oracle 9i displays the query results of the previous time point. However, the table itself has not changed. Oracle 10 Gb enhanced the flashback function to permanently flash back a table. Now, Oracle 10g

We need to inform our storage team of the I/O requirements required to implement Oracle 11i. However, we are confused about choosing 6 k I/O or 8 k I/O. Our database size is 1.6 TB and there are about 1200 concurrent users. What is the best way to

The time consumed when preparing to use the Oracle execution plan mechanism to improve query performance new SQL statements is the most important component of the Oracle SQL statement execution time. However, by understanding the internal execution

Note: Data can be migrated from SQL Server 2000 to Microsoft SQL Server 200064 bits ). You can attach a 32-bit database to a 64-bit database by using the sp_attach_db system stored procedure or sp_attach_single_file_db system stored procedure, you

Environment: oracle10g, operating system 5.2The database system is under rootvg/oracle File SystemThe data file is under datavg/oradata File SystemThe control file is under $/ORACLE_HOME/dbs/AND/oradata.Redo log files in

Index Management and performance challenges of VLDB (super large database)Partition in ASE15)Why use data partitioning?Data availabilityImprove query using data partitionsEffective parallel query processingHow to properly use data

Introduced by Chen Min's blog] MySQL is increasingly used in database applications due to its small size and efficient operations. When I was developing a P2P application, I used MySQL to store P2P nodes. Because P2P applications have tens of

1. First, check the name and file of the tablespace. select tablespace_name, file_id, file_name,round(bytes/(1024*1024),0) total_spacefrom dba_data_filesorder by tablespace_name; 2. Add data files alter tablespace users

With the development of the host DB2 technology, DB2 products have more and more functions, and DB2 products have enhanced their distributed access functions. Therefore, it is increasingly important to correctly configure the stored procedures

Database performance optimization Oracle features: Partitioning technology Partition Index More record tables and indexes. Create an index or partition. Partition Index Basic principle: the physical location of the created table must be different

Guidance:Setting a single database for each instance or server enablesDatabase ManagementMore convenient. However, this will soon increase the cost of your database solution because you need to purchase a new server or a new SQL server license for