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: Set rowcount 1Select col_name from table_name order by col_name desc ...
Latest Answer: You can execute the stored procedure sp_who , this will give you process id which is blocking what. This is more usefull since sometimes user doesn't have restricted permission for master database. ...
Latest Answer: Deferred update is donewhen the updated row does not fit in the same pagewhen the updated row needs to change information on the index pagewhen there is a subquery in the table joinwhen the update happens to the primary key which is being referenced by ...
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 ...
Latest Answer: use gosp_helpgoORuse goselect name,type from sysobjectsgo ...
Latest Answer: The data types supported by Sybase are integer, smallint, tinyint, float, real, double precision, smallmoney, money, decimal, char(n), varchar(n), text, image, datetime, timestamp, timestamp, varbinary(n), binary(n) and bit. ...
Latest Answer: The table in Sybase can be deleted by using the command drop table. The syntax of this command is as below:drop table Then the window waits for entering the table name where the table name to be deleted in Sybase is entered and go is entered which results ...
Latest Answer: Clustered index and Nonclustered indexes are the two type’s index handled by Sybase. In the case of Clustered index the physical and logical order are maintained in the same order by the process of sorting and resorting as required for maintenance ...
Latest Answer: The minimum table size is equal to 1 extent (that is equal to 8 pages). ...
View page << Previous 1 2 3 [4] 5 6 7 Next >>
Go Top
