What are the two types of periodical indexes?
Answer / Amit Kumar Tamrakar
"The two types of periodical indexes (also known as scheduled indexes) in SQL/PLSQL are:
1. Fast Full Index Rebuild: Rebuilds an index quickly but can lock the table during the operation.
2. Slow Full Index Rebuild: Rebuilds an index slowly but does not lock the table, allowing concurrent DML operations."
| Is This Answer Correct ? | 0 Yes | 0 No |
how instead of triger is helpful for mutating tables errors handlling ?
Which software is used for pl sql programming?
what is Complex index. how to create it?
Is sql port 1433 encrypted?
What is meant by temporal data?
What are the indexing methods?
What is the best free sql database?
How many functions are there in sql?
What is the primary key?
What Is a Trigger? How Do You Use It?
What are the types of sql commands?
What is a call statement? Explain with an example.
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)