Latest Answer: I believe we wont be able to clear log segment when secondary truncation point is on.However, we can try running dump tran with truncate_only and checkpoint.could someone with more details shed for some details. ...
Latest Answer: The numeric and decimal typesare identical in all respects but one: Only numeric types with a scale of 0can be used for the IDENTITY column. ...
Latest Answer: usage: dataserver
valid options are:
-a caps_file - path to CAPs directive file
-b [size_spec] - master device size specifier
-c config_file - config file for server
-D [size_spec] - default database size specifier
-d master_dev - master device ...
Latest Answer: Partition is a old technology helps to access data faster (not actually faster) in almost all the databases. Sybase ASE 15.0 opens up a new possiblity of this. Sybase ASE contains semantic Partioning which is not available in Oracle latest version called ...
Why can a user create 249 non clustered indexes over a given table as against only one clustered index over a table?
Latest Answer: The data that are fetched by the SQL (select statement) is completely fetched from the index itself is called index covering.Example:-- TableA has 10 columns Col1, Col2, Col3, Col4, Col5...-- An index idx_TableA on TableA has composite non-clustered index ...
Latest Answer: select * from where = (select max() from ) ...
Latest Answer: Deferred updates are carried out by adaptive server. Generally in deferred updates the affected rows are analyzed and further updations needed on these rows are carried out by the adaptive server. In the process of deferred updates the log record is analyzed ...
Latest Answer: Index are handled automatically by Sybase database to speed up the query and in short to optimize the query .But in certain scenarios and situation the user may need to force the index for handling the inaccurate results shown by optimizer. This concept ...
View page << Previous 1 2 [3] 4 5 6 Next >>
Go Top
