Viewing 15 posts - 1 through 15 (of 16 total)
Clustered indexes are stored within the referenced table and not in memory. Memory is volatile so if the indexes were stored there they would have to rebuilt every time...
March 25, 2013 at 8:00 am
@sean lange As per my knowledge when you create a non clustered index on a table column they occupy some space in memory as a hash tree...
March 21, 2013 at 9:20 am
tim_harkin (3/21/2013)
If you are talking about the index definitions, then yes they are still there. Index data is gone - their pages are deallocated as well.
I mean to say...
March 21, 2013 at 9:07 am
GilaMonster (3/2/2013)
CREATE TABLE student ( name VARCHAR(20), age INT );
INSERT INTO student
VALUES ( 'ram', 12...
March 2, 2013 at 10:12 pm
The database engine is oracle!!! and I am trying to display odd number of records in table!
March 2, 2013 at 10:10 pm
create table student
(name varchar(20),age int);
insert into student values('ram',12);
insert into student values('shyam',13);
insert into student values('balu',14);
By processing the 2nd query the output I get is
name age
ram ...
March 2, 2013 at 11:37 am
Thank you for your explaination it cleared all the doubts!!!
March 2, 2013 at 12:44 am
If, in the second query, you had dropped the alias from the table in the inner query you would have gotten the same answer as in the first query
Then...
March 2, 2013 at 12:13 am
@Lynn thank you for your answer it helped me but i have a doubt which is that why does not this happen in case when the alias is...
March 1, 2013 at 10:23 pm
Thank you for your reply but can you please explain by giving a more elleborate explaination It would be very helpful!!
March 1, 2013 at 11:55 am
Viewing 15 posts - 1 through 15 (of 16 total)